Definitions
Sorry, no definitions found. Check out and contribute to the discussion of this word!
Etymologies
Sorry, no etymologies found.
Support
Help support Wordnik (and make this page ad-free) by adopting the word mysqldump.
Examples
-
If you send me a MySQL dump (i.e. mysqldump wordpress_database comments_table/tmp/comments. mysqldump) then I would be happy to scan it and return it sans spam.
-
The most frustrating part of this was that I knew that what was in the database was valid utf8 data – mysqldump proved this when viewing the file showed the proper characters (given the proper LANG environment variable) and also od over the characters looked good to me.
-
The solution, simply enough, was to mysqldump the table out and change all instances of latin1 to UTF-8 in the file and reload it (ensuring that the connection itself was UTF-8) – this loaded in all my precious, pre-existing UTF-8 data without twiddling any of the bits.
-
He recommends backing up your web server with rsync and a regular mysqldump command.
Free Tools To Back Up Your Online Accounts | Lifehacker Australia 2009
-
The syntax for your command that you want in cron is mysqldump - u - p - h backup. sql
-
Dumped them all: for db in $cat dblist.txt; do mysqldump --opt -u user -ppassword ${db} ${db}-20060712.sql; done
Finally out of MySQL encoding hell — Climb to the Stars 2006
-
Just a quick note – it is wise to specify the character set when exporting/dumping from mysql with mysqldump, using the –default-character-set=latin1 command.
Converting MySQL Database Contents to UTF-8 — Climb to the Stars 2004
-
Where to write this? mysqldump –opt -u root -p wordpress wordpress.sql
Converting MySQL Database Contents to UTF-8 — Climb to the Stars 2004
-
Where to write this? mysqldump –opt -u root -p wordpress wordpress.sql
Converting MySQL Database Contents to UTF-8 — Climb to the Stars 2004
-
Just a quick note – it is wise to specify the character set when exporting/dumping from mysql with mysqldump, using the –default-character-set=latin1 command.
Converting MySQL Database Contents to UTF-8 — Climb to the Stars 2004
Comments
Log in or sign up to get involved in the conversation. It's quick and easy.