Jump to content

Uploading large MYSQL databases to PHPmyAdmin


Guest atmmultimedia

Recommended Posts

Guest atmmultimedia

Hello there,

 

I've been creating wordpress sites locally and the databases exceed over 2.4MB. I'd like to know how you can upload and connect a large MYSQL databse to PHPmyadmin. What happens is on a hosting account if you upload a database thats over 2.5mb it will timeout.

 

Any help would be great.

 

Thanks,

Link to comment
Share on other sites

Even though the database size might be 2.4MB, the generated SQL Dump shouldn't be the same size.

 

If you're using "MYSQL Admin" then you can export the whole database as a text *.sql file which will have the table structure + data which can be dumped into another MySQL database. You can do this by the "Backup" option of the MySQL Admin program.

 

If you're using PHPMyAdmin to export your data then you want the "Export" tab when you're not browsing any tables (i.e just after you've selected your database), highlight all the tables you want to export, then select the SQL option.

 

 

If you're saying the generated *.sql file is 2.4MB then you can most likely just split this file into 2-3 chunks by splitting the file between different CREATE TABLE or INSERT INTO statements then importing them 1 by 1.

Link to comment
Share on other sites

  • 1 month later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...