Pretty new to wordpress. currently using CPanel.
Recently a site crashed after an update, I have a backup I want to restore.
Its a .sql file. Upload goes fine until at line 31 I get error 1050;
Error: The system failed to execute the database script with the following errors: ERROR 1050 (42S01) at line 31: Table ‘wp\_actionscheduler\_actions’ already exists
​
The table doesnt exist. I am starting from a blank database…
What do?
It seems there’s an attempt to create the table twice. Need to open the sql file with an ordinary text editor (like notepad++) and inspect the syntax for stuff like this. Look at this [StackOverflow question](https://stackoverflow.com/questions/25787544/table-already-exists-error-when-trying-to-import-sql-file). This is [another article](https://support.cpanel.net/hc/en-us/articles/360053076393-Manually-importing-a-database-is-causing-a-Table-already-exists-error) addressing CPanel specifically.
Did you delete all tables from the database before uploading the new one? If they already exists, you cant overwrite them