![]() Richardson RazorSQL is a query tool, database editor, SQL, and the navigation database. (in case you don't have the free disk space) mysqldump -single-transaction -u user -p | gzip > RazorSQL 10 - A query tool, database editor, SQL, and the navigation database. And since this does not lock your tables for most queries you can actually pipe the dump | directly in gzip. It prevents the tables being locked but still result in a solid backup! See docs here. Information_schema.tables WHERE table_schema NOT IN ('information_schema','performance_schema','mysql')) A Īnd then execute your dump like this: mysqldump -u user-p > dumpfilename.sql
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |