Top "Mysqldump" questions

MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL).

mysqldump table without dumping the primary key

I have one table spread across two servers running MySql 4. I need to merge these into one server for our …

mysql mysqldump load-data-infile
error mysql : Got a packet bigger than 'max_allowed_packet' bytes

for import mysql database give me this error : $ `mysql -u user -p password zxc_db < zxc.sql` ERROR 1153 (08S01) …

mysql mysqldump mysql-error-1064
mysqldump and restore with special characters. øæåØÆÅ

Locally I do this to dump and move a database, upgrading silverstripe 2.3 to 2.4: mysqldump --opt --default-character-set=latin1 --skip-set-charset --user=$root …

mysql mysqldump silverstripe
Importing 1GO SQL File => ERROR 2013 (HY000) at line 23: Lost connection to MySQL server during query

Ive got to import 1go of sql data, i raised up the max_allowed_packet to 1100M to be sure. …

mysql sql mysqldump mysql-management
How can I slow down a MySQL dump as to not affect current load on the server?

While doing a MySQL dump is easy enough, I have a live dedicated MySQL server that I am wanting to …

mysql backup replication mysqldump backup-strategies
Mysql ERROR: ASCII '\0' while importing sql file on linux server

I am getting following error while importing sql file ERROR: ASCII '\0' appeared in the statement, but this is …

mysql phpmyadmin mysqldump mysqlimport
Compare structures of two databases?

I wanted to ask whether it is possible to compare the complete database structure of two huge databases. We have …

mysql database compare structure mysqldump
Too many open files error on Ubuntu 8.04

mysqldump: Couldn't execute 'show fields from `tablename`': Out of resources when opening file './databasename/tablename#P#p125.MYD' (…

mysql linux mysqldump ubuntu-8.04
Can't get mysqldump to connect to local mysql instance (error 2003 / 10061)

I've got mysql 5.1 on a windows xp machine. It's listening on port 3308. I'm trying to use mysqldump: > mysqldump -u …

mysql mysqldump mysql-error-2003
Mysqldump: create column names for inserts when backing up

How do I instruct mysqldump to backup with column names in insert statements? In my case I didn’t a …

mysql mysqldump database-schema