SQL problems

[Harrison]

The sql backup file needs to be on the same server as you wish to restore the database too.

To restore the database you just need to run a mysql command in the shell

mysql -h[database server] -u[username] -p[password] databasename < backupfile.sql

So if your database server is called db01.domain.co.uk, the database is called db1001, username is fred, password is cheese, and the database backup is called backup.sql, then the command would be:

mysql -hdb01.domain.co.uk -ufred -pcheese db1001 < backup.sql

[Stephen Coates]

Done that. Now I get this error:

mysql -hlocalhost -uclockwis_phpBB -p******** clockwis_phpBB < public_html/dump/dump.sql

ERROR 1045 (28000) at line 82321: Access denied for user 'clockwis_phpBB'@'gaius.asmallorange.com' (using password: YES)

Any ideas as to what that means?

[Harrison]

Are you sure you have the right username and password? Normally that error is because you have the root username or password wrong. It isn't always identical to the ftp access details.

[Stephen Coates]

I don't know anything about root user names.

All I know is that the database name is clockwis_phpBB, the username for that database is clockwis_phpBB and that the password is ********. It does restore some of the database before the error appears.

[FOL]

I don't know anything about root user names.

All I know is that the database name is clockwis_phpBB, the username for that database is clockwis_phpBB and that the password is ********. It does restore some of the database before the error appears.

By root user, it means your main account user and pass. Thats why its saying incorrect, i used to get this a couple of times, as i kept forgetting to use my root account name and pass.

[Stephen Coates]

Success at last!

I have finally managed to fix all the errors thanks to you lot and the guys at the hosting companies technical support.

The database now seems to work, and I now know to always make sure I have the correct settings when exporting a database.

[Harrison]

Great to hear you finally got everything back and working again. It definitely took some work on your part to get it all to import.

Most important thing. Have you now made another backup from the newly restored database?