[RESOLVED] empty tables

[leagal4ever]

Hy again!
Yesterday i make new windows and i just copy mysql folder now i copy data in current and i get proper database name but no tables 😕 im sure i shold export but its not small and one per one is big job.

[bradgrafelman]

If you copied the entire data folder over, I would assume that it would work.

Best bet is to do a database export, however, e.g. from the command line.

[leagal4ever]

If i copy all i get error i copy all folders and replace some files and its works, can you tell me how import/export from command line i would like make backup for all.

[bradgrafelman]

mysqldump --user=USERNAME --pass=PASSWORD DB_NAME >db_backup.sql

Would dump one entire database to a file called db_backup.sql. If you wanted to dump all databases, you could do:

mysqldump --user=USERNAME --pass=PASSWORD --all-databases >server_backup.sql

More info about the mysqldump program can be found in the MySQL manual here.

[leagal4ever]

A lot info in short time 🙂 thanks!