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
I had to delete from some records from a table so before doing that I took this table\'s backup using mysqldump command.
I have a bash script mysql_cron.sh that runs mysqldump #!/bin/bash /usr/local/mysql/bin/mysqldump -ujoe -ppassword > /tmp/somefile
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?
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
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).
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.
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
I was wondering how I can get the following file, mysqldump -h server -u root -p --all-databases > all_dbs.sql
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\" );