Startseite Beiträge von Heute Kalender Boardsuche Benutzerliste FAQ Deine Einstellungen ändern Neue Beiträge
Navigation
Go Back   Mambo / Joomla Hosting Talk (MHT/JHT) > Hosting Forums > Server Management
User Name
Password
Reply
 
Thread Tools Display Modes

  #1  
Old 05-31-2005, 01:32 PM
jomaco1's Avatar
jomaco1 jomaco1 is offline
Super Moderator
 
Join Date: Mar 2005
Posts: 168
Default phpMyAdmin...restoring from large files

I have a db backup file that is over 4MB. phpMyAdmin says (under the query window) "Max: 2,048MB" for running a query from a text file. Is there another way to restore from a text file without having to break the file down into smaller files?
__________________
Mark
Reply With Quote
  #2  
Old 05-31-2005, 01:37 PM
keliix06 keliix06 is offline
Administrator
 
Join Date: Mar 2005
Location: Minneapolis, MN
Posts: 394
Default

That's because of the php filesize limit. Breaking it up (I would just copy/paste parts directly into phpMyAdmin) would be best to keep the server from overloading.
__________________
Doyle Lewis - BuyHTTP Internet Services
keliix06 [at] gmail.com
Reply With Quote
  #3  
Old 05-31-2005, 01:39 PM
Mambohut's Avatar
Mambohut Mambohut is offline
Administrator
 
Join Date: Mar 2005
Location: New Jersey, USA
Posts: 272
Default

You can upload it to the server and run this command from sxxxx as root
#mysql -uroot -p dbname < db.sql
__________________
Michael Morris - Buyhttp Internet Services
Webmaster [AT] Mambohut.com
Buyhttp.com - Your Mambo/Joomla
Friendly Hosting Providers
Cloud Hosting - True Cloud Hosting from a trusted name!
Reply With Quote
  #4  
Old 05-31-2005, 01:43 PM
jomaco1's Avatar
jomaco1 jomaco1 is offline
Super Moderator
 
Join Date: Mar 2005
Posts: 168
Default

Thanks guys!
__________________
Mark
Reply With Quote
  #5  
Old 05-31-2005, 06:50 PM
mambovince mambovince is offline
Junior Member
 
Join Date: May 2005
Posts: 2
Default

If you don't have command line access, this seems to be made for such situations:

http://www.ozerov.de/bigdump

- Vince
Reply With Quote
  #6  
Old 05-31-2005, 07:09 PM
jomaco1's Avatar
jomaco1 jomaco1 is offline
Super Moderator
 
Join Date: Mar 2005
Posts: 168
Default

Thanks! That's definitely worth taking a look at.
__________________
Mark
Reply With Quote
  #7  
Old 06-14-2005, 05:48 PM
mambovince mambovince is offline
Junior Member
 
Join Date: May 2005
Posts: 2
Default

Hi Mark,
did it work out for you?

- Vince
Reply With Quote
  #8  
Old 06-25-2005, 07:24 PM
buglerroller's Avatar
buglerroller buglerroller is offline
Junior Member
 
Join Date: Jun 2005
Posts: 10
Default

yo should try to compress(gzip works the best) your sql file before upload. had the same issue and before changes to time/file_size limits were changed, compression was the best route.
__________________
www.tCtunerZ.com
-|-Mambo/OSC CMS Driven Web Site -|-
Scion tC Aftermarket Tuning

is it too early to mourn, is it too late to ride
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 02:03 PM.

Home . Members . FAQ . User CP . New Posts . Today's Posts . Media Kit
 
Joomla Top Sites - Your Primary Source of Joomla Traffic
Web Hosting . Mambo Tutorials . Joomla Hosting . Mambo Hosting . Joomla Top Sites . Joomla Advertising . Web Hosting Flash Tutorials . Joomla & Mambo Freelancers . Joomla Template Providers
Powered by vBulletin - Based on design by vbdesigns.de - © 2005 - 2006 by BuyHTTP Internet Services
Top Top
vRewrite 1.5 beta SEOed URLs completed by Tech Help Forum and Chalo Na.