Trying to restore a database in mariadb on Debian 11

[limdim]

If anyone can assist that'd be great

I'm trying to restore a db on mariadb using this command and get the following error

mysql -u root -p wordpress < all-databases.sql
Enter password:
ERROR 1050 (42S01) at line 805: Table 'user' already exists

any idea?

 

[gvisoc]

The error is in your script, not in the fact you’re using Debian.

Check in line 805 and if you’re trying to create a table named user, you may have added it before in the script or in a previous try.

You can get past the error adding the clause “IF NOT EXISTS”: “CREATE TABLE user IF NOT EXISTS”,

You should check Mariadb’s documentation.