iecwillow Posted September 1, 2005 Share Posted September 1, 2005 I tried many times to restore a 20,103,833 bytes database by using Database Backup Manager in admin without success, then I went through phpmyadmin try to dump the file in mysql, but the Max file allowed is 15,360KB.... Is there any other way I can restore the database? Thanks for any help.... Link to comment Share on other sites More sharing options...
iecwillow Posted September 1, 2005 Author Share Posted September 1, 2005 My database file is a pure SQL file, no compression. Please help.... Thanks. Link to comment Share on other sites More sharing options...
iecwillow Posted September 2, 2005 Author Share Posted September 2, 2005 anyone... please....? Link to comment Share on other sites More sharing options...
iecwillow Posted September 2, 2005 Author Share Posted September 2, 2005 Still waiting for help.... please.... Link to comment Share on other sites More sharing options...
iecwillow Posted September 2, 2005 Author Share Posted September 2, 2005 please.... Link to comment Share on other sites More sharing options...
Guest Posted September 2, 2005 Share Posted September 2, 2005 have you tried with the easy populate contribution? Link to comment Share on other sites More sharing options...
iecwillow Posted September 2, 2005 Author Share Posted September 2, 2005 Thanks for your advice. I didn't try the easy populate contribution. I believe it's a great contribution but only good for insert products or restore. I don't want lose all other important parts in the database such as registered customer's account, products' reviews, best viewed report... etc. So I still need help for restore the whole database... Link to comment Share on other sites More sharing options...
Rob123 Posted September 2, 2005 Share Posted September 2, 2005 If your host allows you to connect to your database server remotely there is an alternative for you: Instead of using phpMyAdmin, use a desktop application such as SQLyog Free Edition. It has the look and feel of M$ Query Analyzer. (I liked it so much, I actually purchased the Enterprise version.) Search Google for it... and no I do not own nor work for the company. :) HTH, Robert Link to comment Share on other sites More sharing options...
iecwillow Posted September 2, 2005 Author Share Posted September 2, 2005 Thank you. Unfortunately my hosting company blocked the remote access. Link to comment Share on other sites More sharing options...
iecwillow Posted September 2, 2005 Author Share Posted September 2, 2005 None of you meet the same problem as me? As long as the site is keep runing, more and more info added into the database, eventually we will have to face this, isn't it? In my experience, it's easy to restore any database file under 10MB, but can not go any larger... Link to comment Share on other sites More sharing options...
Rob123 Posted September 3, 2005 Share Posted September 3, 2005 You have a few choices in order of my preference... 1. Break your 20 mb file into two smaller files. (The backup file is really a plain text file that you can edit with text editor like notepad) 2. Ask your host to increase the 15,360KB limit 3. Edit your 20mb and delete some of the "unnecessary" inserts. 4. Ask your host to open port 1306 for remote access. 5. Ask your host for advice or a recommended plan of action. HTH, Robert Link to comment Share on other sites More sharing options...
Jack_mcs Posted September 3, 2005 Share Posted September 3, 2005 Your hosts control panel should have shell access. In that case you can use mysql to upload the file. Have you asked your host to help you with this? Some of the better ones will upload it for you. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.