How to import a very large phpmyadmin request?

Question

if my host does not allow me to upload the file directly to my mysql folder and can I do this only through phpmyadmin? Are there any alternatives besides its own import function, so that my connection will not be timeout when loading a request of about 8 MB?

Answer 1

you can gzip or bzip the file, and phpMyAdmin will unzip and run the script.

otherwise, what I had to do in the past was to split my SQL into several files and load each separately. You can do this simply by opening the SQL file in a text editor, scroll down half the way, find the beginning of the statement and move everything after that to another file.

Answer 2

Do not use phpmyadmin for anything critical. Definitely do not use it to back up or restore. This is a trash bag.

Enter your shell and use the mysql command-line client to restore the database in the standard way. If you cannot do this, get the best supplier.

Shell access is required to work with mysql databases.

Do not expect that with phpmyadmin nothing will happen to destroy all your data.

Answer 3

BigDump?

Step-by-step import of large and very large MySQL dumps (for example, phpMyAdmin 2.x Dumps) even through web servers with tight runtime and in safe mode. The script executes only a small part of the huge dump and restarts itself. The next session begins by stopping the latter.

You can download the dump using an FTP client (which will allow you to resume transferring) and download it locally.

Answer 4

I would definitely say BigDump. I had this exact problem with a 8.3 GB sql file. Read this article for more information. How to upload a large SQL file to MySQL also visit the script homepage to download it.

Answer 5

See my answer here: fooobar.com/questions/1280026 / ...

If during the import operation you disable partial import → Allow import interruption ... then phpMyAdmin seems to send the whole thing to mysql, which is processed slowly. Unfortunately, phpMyAdmin (at least on my shared host) will no longer respond to requests, but the browser works with a different IP address and allows you to track the progress of the request.

Answer 6

I say use Sypex Dumper .