Guest atmmultimedia Posted September 27, 2010 Report Share Posted September 27, 2010 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, Quote Link to comment Share on other sites More sharing options...
newseed Posted September 27, 2010 Report Share Posted September 27, 2010 You can try using BigDump. Quote Link to comment Share on other sites More sharing options...
BeeDev Posted September 27, 2010 Report Share Posted September 27, 2010 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. Quote Link to comment Share on other sites More sharing options...
jlhaslip Posted October 28, 2010 Report Share Posted October 28, 2010 Try uploading a single Table at a time and add the indexing afterwards. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.