fatbloke Posted December 12, 2005 Share Posted December 12, 2005 Hi I want to backup my current large mysql data over 26,000kb and import into a new mysql. The normal b/up - restore does not work because the file is so big ... the file splitters I have tried say "no query " when i import the sections What am I doing wrong and is it ok to import into a new dbase with a different name ? Thanks Roy Link to comment Share on other sites More sharing options...
Kornie Posted December 12, 2005 Share Posted December 12, 2005 Use phpmyadmin and download the whole database Link to comment Share on other sites More sharing options...
fatbloke Posted December 12, 2005 Author Share Posted December 12, 2005 Hi done that ..the dbase is too big to import / restore in one hit ... splitting doesnt work - errors no query. I also heard its not possible to import into a dbase thats not the same name as backup one ....cant see that being correct though I have been trying every which way for 2 weeks now Link to comment Share on other sites More sharing options...
Kornie Posted December 12, 2005 Share Posted December 12, 2005 try to export only a few tabs via phpmyadmin, export the first 10 tabs, then the next 10 tabs and so on. you can put them together at least. do you use sessions? if so, do not export the tab session, also user_tracking, you don't need this two tabs for backup. Link to comment Share on other sites More sharing options...
Kornie Posted December 12, 2005 Share Posted December 12, 2005 import the same, try step by step 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.