mysqldump
MySQL - how to backup database to a different server?
I have 2 databases with MyISAM tables which are updated once a week. They are quite big in size (one DB is 2GB and the other is 6GB). I currently back them up once a week with mysqldump and keep the l[详细]
2023-01-15 14:59 分类:问答Recreate mysql database structure and stored procedures
I have a set of MYSQL tables on the development server 开发者_Python百科that I need to place on the production server. How can I \"recreate\" all of them?[详细]
2023-01-15 05:47 分类:问答how to stop mysqldump from recording as slow queries
Im recording slow queries longer than 2 seconds. That is running fine except, the daily backups also get recorded in slow log because 1) mysqldump calls select * from xyz (big table); and 2) when inse[详细]
2023-01-14 14:46 分类:问答Django - dumpdata truncate to last n lines
Does anyone have a simple solution to using (or modifying) dumpdata to trucate a simple table down to the last n lines.I like to use dump data for test fixtures but the data size has 开发者_开发技巧go[详细]
2023-01-14 07:39 分类:问答Python subprocess, mysqldump and pipes
I\'ve got a problem trying to build a easy backup/upgrade database script. The error is in the mysqldump call using subprocess:[详细]
2023-01-13 22:04 分类:问答How do I restore one database from a mysqldump containing multiple databases?
I have a mysql dump with 5 databases and would like to know if there is a way to import just one of开发者_JS百科 those (using mysqldump or other).[详细]
2023-01-13 20:20 分类:问答a bash script to dump a database
how to write a bash script which will dump 开发者_StackOverflowa database and restore it. there should be two arguments. first one is the name of db which is going to be dumped and another one is name[详细]
2023-01-09 09:58 分类:问答how to backup all DB info using mysqldump?
I want not only the \"Create table\" statements, but also the Inserts. What flags should i pass to mysqldump?[详细]
2023-01-08 15:45 分类:问答How to restore data from MYSQL dump without any duplicate key errors?
Everytime I t开发者_开发问答ry restoring the dump, I get : ERROR 1062 (23000) at line 10297: Duplicate entry \'spaß\' for key \'PRIMARY\'[详细]
2023-01-08 11:55 分类:问答Is there a convenient way to include a mysqldump in my git commits?
Especially if I\'m using GitHub? If not, should I (or perhaps开发者_运维技巧 someone else) work on such a tool?add a script that dumps the sql file someplace specific to your project (but inside the[详细]
2023-01-08 07:58 分类:问答