mysqldump
dumping a mysql table to CSV (stdout) and then tunneling the output to another server
I\'m trying to move a database table to another server; the complication is that the machine currently running the table has little to no space left; so I\'m looking for a solution that can work over[详细]
2023-02-11 14:15 分类:问答What does mysqldump < do? Live site database mistake, almost shat my pants
I had to delete from some records from a table so before doing that I took this table\'s backup using mysqldump command.[详细]
2023-02-10 20:39 分类:问答Mysqldump creates empty file when run via cron on linux
I have a bash script mysql_cron.sh that runs mysqldump #!/bin/bash /usr/local/mysql/bin/mysqldump -ujoe -ppassword > /tmp/somefile[详细]
2023-02-10 16:10 分类:问答what's the difference between -C and gzipping a mysqldump?
I want to do a mysqldump directly to my remotehost. I\'ve seen suggestions to use the -c switch or use gzip to compress the data on the fly (and not in a file). What\'s the difference between the two?[详细]
2023-02-09 17:27 分类:问答How do you fix the username not showing up in mysql?
im creating a registry for my website, and so far its all good, but when you register, it doesnt put the username into the database, its puts the password and email though[详细]
2023-02-08 22:52 分类:问答mysql - how does mysqldump work?
I have a java application that uses mysql as back end, every开发者_Python百科 night we take a backup of mysql using mysqldump and application stops working for that time period(app 20 min).[详细]
2023-02-08 19:37 分类:问答Comparing two databases with mysqldump?
I have two mysql databases which should be identical to each-other.One was made by an old version of a script and another was made a new refactored version.[详细]
2023-02-06 14:57 分类:问答Backing Up MySQL Database Only With MySQL Command
I\'ve got this very strange web host开发者_运维技巧, it\'s the weekend and the sysop isn\'t available, and we need to make changes to the site. To do that, we need a database fallback position, so a d[详细]
2023-02-06 12:57 分类:问答MySQL Dump All Databases and Create (or Recreate) them on Import?
I was wondering how I can get the following file, mysqldump -h server -u root -p --all-databases > all_dbs.sql[详细]
2023-02-06 06:50 分类:问答mysql escaping single and double quotes
I have a script that i am writing to move certain fields to a new db like $results = mysql_query ( \"SELECT body, titleFROM $source_db.Post\" );[详细]
2023-02-06 05:46 分类:问答