8 Kasım 2010 Pazartesi

mysqldump problem

mysqldump is a powerful tool for exporting, importing databases but it has
really big problems with different mysql versions. Even one or two version changes makes tool to produce unstable results. When you execute a command like
mysqldump -u root any_database < dumped.sql
it just shows some comments on the console but any changes reflected to database. After losing about 3 or 4 hours i've found another way to import exported data. On the command line,
$ mysql -u root

mysql>use any_database;

mysql>\. /path/to/sql/file or
mysql>source /path/to/sql/file

After that mysql starts to execute the sql file and problem goes away...

Hiç yorum yok:

Yorum Gönder