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 分类：问答