Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Programming/Scripts

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 14th November 2006, 18:11
gary1974 gary1974 is offline
Junior Member
 
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to gary1974 Send a message via Yahoo to gary1974
Default please help...restore 180 mb backup

i have my back up of mysql. i want to restore it. how can i restore that using myphpadmin. is there another way to restore my backup? please advice

gary..
Reply With Quote
Sponsored Links
  #2  
Old 15th November 2006, 16:25
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

180MB are too much for phpMyAdmin. But you can do it on the command line: http://www.howtoforge.com/faq/6_4_en.html
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 28th January 2007, 03:59
sridhar sridhar is offline
Junior Member
 
Join Date: Jan 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

or, much easier: use BigDump.
Reply With Quote
  #4  
Old 30th January 2007, 13:08
zcworld zcworld is offline
Senior Member
 
Join Date: Jul 2006
Location: South Australia
Posts: 329
Thanks: 2
Thanked 37 Times in 37 Posts
Send a message via MSN to zcworld Send a message via Skype™ to zcworld
 
Default

when i gotta restore backups of anything from 20 to 40 mb
i always TGZ them down
and copy over the the box
make sure my sql server can handle XXX filesize on imports than import via command line
i find its easier
than to do so from mysql or web phpmyadmin interface

mysqld < filename.sql -u name -p
walk away and comes back in 5 mins job done

but
its comes do :
do you have access to mod the mysql settings on the filesize it can handle
if so than upload the sql file mod the mysql server setting , restart mysql .. than import via that command up there
Reply With Quote
Reply

Bookmarks

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting up a backup mail server setup with two installations of ISPConfig zitch Tips/Tricks/Mods 7 30th December 2006 10:07
Backup and restore on Debian 3.1 Sarge arve Tips/Tricks/Mods 1 14th October 2006 15:17
backup and restore provell Installation/Configuration 4 2nd May 2006 12:21
Backup restore on ispconfig misterm Installation/Configuration 0 18th December 2005 23:32
backup / restore Hellbound General 1 22nd September 2005 10:11


All times are GMT +2. The time now is 03:19.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.