Solved

mysql import/restore database from large mysqldump file

Posted on 2014-04-06
3
715 Views
Last Modified: 2014-04-10
running latest WAMP and associated components on win7 pro 64bit. mysql version 5.6.12.

I'm creating daily backups using mysqldump, which creates a growing 338,521kb file which zips to 42,507kb.

using phpmyadmin to import this file yields an error that file is too large.

I'm looking for a process/solution to this that I can have an admin execute.
tks
0
Comment
Question by:jsgould
3 Comments
 
LVL 5

Accepted Solution

by:
JurajUQU earned 250 total points
ID: 39981865
You can do it via commandline

mysql -u username -p database_name < file.sql
0
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 250 total points
ID: 39981868
Typically PHP uploads are limited to 8 MB in 'php.ini'.  There is also the issue of the upload timing out if it is too large.  You need to change 'post_max_size', 'upload_max_filesize', and probably 'memory_limit' and 'max_execution_time'.

The alternative is to use the 'mysql' command line to do the import.  Log in as 'root' and use '< backup.sql' to restore everything that was dumped.  http://dev.mysql.com/doc/refman/5.6/en/mysql-batch-commands.html

Also from http://dev.mysql.com/doc/refman/5.6/en/copying-databases.html :
You can also use mysqldump and mysqlimport to transfer the database.
0
 

Author Closing Comment

by:jsgould
ID: 39992259
thks
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now