SQL Dump Help

Alright im trying to perform a bigdump on my sql because it wont import normally cause its to big. When i perform this i get the error message:

MySQL: Can't create database '2213_bat'; database exists

So basically what it tells me is that it already exists so what i do is delete it and then run the program again but then i get a message saying that the user doesnt have access to the database even though it doesnt exist.

So does anyone know how to fix this or ever run into this problem before?

 

You need to run the import as a user with create database privileges, the admin user is a good choice.
Find the manual for the mysql import command look for the username parameter, that should do the trick.

 

If you are using mysql + linux


To create the dump you can use the command

mysqldump -u username -D dbname -p > dump.sql

To import the dump

use the command as root

mysql -u username -p -D dbname < dump.sql

You need to make sure you create a new database with the dbname before executing the command

 

this command has bugs with UTF8 encoding

 

Are you using the right tool ?
I find http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html
4.5.5. mysqlimport — A Data Import Program

And if this has an UTF-8 problem, well .., that should not be the case right ?

 

Yes that solved the problem thanks for the advice.

 

Altough I think the problem with the mysql command is due to your OS/Shell/pipe support.
If this is fully setup as unicode, then the mysql < version should work as well, unless the mysql program uses different dataparsing routines then mysql_import