mysqldump
Free space in MySQL after deleting tables & columns?
I have a database of around 20GB. I need to delete 5 tables & drop a few columns in some other 3 tables.[详细]
2023-01-29 02:06 分类:问答SQL dumping is locking the database and crashing my website [duplicate]
This question a开发者_JAVA百科lready has answers here: Closed 12 years ago. Possible Duplicate: Run MySQLDump without Locking Tables[详细]
2023-01-28 19:05 分类:问答using mysqldump with where option and a long argument list in bash script
I开发者_如何学C am trying to dump a subset of a table in MySQL with mysqldump. I have the id values of rows that I want to select from the table, stored in a file. When I use these values as a variabl[详细]
2023-01-28 01:06 分类:问答Is it possible to dump a mysql schema into latex tables? [closed]
Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the problem by editing this post.[详细]
2023-01-27 16:58 分类:问答Is it viable to handle MySQL backups with git?
Today I had this really neat idea for backing up my database: put the dump file in a git repository, then commit on each dump so that I have both the most recent copy, but can easily roll back to any[详细]
2023-01-26 20:38 分类:问答Mysqldump specific stored procedures/functions but not others
I know that mysqldump does not include stored procedures/functions by default and that you have to use the -routines to include them. I am also aware that to dump just the functions and stored procedu[详细]
2023-01-26 17:56 分类:问答While taking table backup using mysqldump command, can we skip particular column..?
I need to know, is there any option to skip particular column and take remaining table backu开发者_运维技巧p using mysqldump command.[详细]
2023-01-26 11:29 分类:问答Extracting an existing schema in MySQL, getting an unknown error, need help
Trying to dump the schema for an existing MySQL database. Appears the best way is this command: CMD: mysqldump -d -u root -pPASSWORD_REMOVED MyOffice[详细]
2023-01-25 14:39 分类:问答MySQL keys: PRIMARY KEY, FOREIGN KEY, KEY -- what is "KEY"?
Looking at a \"mysqldump -d\" and see a key that is KEY, not \"PRIMARY KEY\" or \"FOREIGN KEY\" What is KEY?[详细]
2023-01-25 12:00 分类:问答Is there a good and free software to backup a mysql database?
I\'m looking for a software or script to make a daily backup (automatic) of a mysql database. Any suggestions?[详细]
2023-01-24 12:01 分类:问答