tags:

views:

42

answers:

1
+1  Q: 

mysqldump takes very long time to restore a backup, what's wrong ?

The backup was made using phpMyAdmin with extended inserts enabled and is ~80MB in size. mysqldump does not complain restoring it (yet!) but it takes a long (>2 hours) time to do so. Insights ?

Very stupid of me, I was using a wrong syntax. Reading the manuals fixed it :-)

A: 

Try restoring by first deleting any index on that table.

codaddict  2010-09-15 09:03:40

related questions

mysql dump tables only
Edit very large sql dump/text file (on linux)
How can I access the MySQL command line with XAMPP for Windows?
MySQL Import Database Error because of Extended Inserts
How to create an identical gzip of the same file?
mysql dump outside the command line
Complex Database Backup
What is the best way/tool to synchronize two MySql servers (not in the same cluster).
Dump mysql view as a table with data
How do I suppress the row count for tables added (AUTO_INCREMENT=N) to mysqldump output?
Problem importing mysql procedures generated from mysqldump --routines
Too many open files error on Ubuntu 8.04
script to convert mysql dump sql file into format that can be imported into sqlite3 db
How to get the exact same output from mysqldump as mysqladmin/backup
How to obtain a correct dump using mysqldump and single-transaction when DDL is used at the same time?
Skip certain tables with mysqldump
MYSQL - How would I Export tables specifying only certain fields?
MySQL permissions issue - should be non-issue
How can I use mysqldump to replicate views between accounts?
Does mysqldump --password really do what it says?
Limiting the number of records from mysqldump?
How do I restore a MySQL .dump file?
Run MySQLDump without Locking Tables
Migrating from MySQL to arbitrary standards-compliant SQL2003 server
mysqldump | mysql yields 'too many open files' error. Why?