Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 13 May 2006, 22:52
Battle_Ring Battle_Ring is offline
 
Join Date: Apr 2004
Importing 60mb database

hello im trying to move my forum to a new host but it wont load using import in phpmyadmin because it says the file is too big is there any other way
Reply With Quote
  #2  
Old 14 May 2006, 00:16
bairy bairy is offline
 
Join Date: Oct 2005
Real name: Chris
If you have shell access, use that. I don't know the linux commands for command line sql so someone else will have to help with that.


Otherwise, you could split the textfile up into small chunks of 1mb or so. So long as create table 'paragraphs' are kept together you can split on any line. It's tedious and it will be slow, but it will work.
Reply With Quote
  #3  
Old 14 May 2006, 00:36
Kirk Y's Avatar
Kirk Y Kirk Y is offline
 
Join Date: Apr 2005
Yeah I'm on an IIS server -- so splitting up our SQL restores is insanely annoying.

Anyway, I've still got the code we used when we were on a Linux host.

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

It's fairly self-explanatory, stocks2 is the database you're restoring to and stocksdb.sql is the file/path/to/your/sql/file.
__________________
Former vBulletin.org Staff Member

Please feel free to re-use any of the code in any of my projects submitted to vB.org, so long as original attribution is retained.

Last edited by Kirk Y; 14 May 2006 at 00:41.
Reply With Quote
  #4  
Old 14 May 2006, 00:39
Hellcat Hellcat is offline
 
Join Date: May 2003
Real name: Michael
You could also upload the .sql file viy ftp and let a custom php script do the import (assuming max. execution time isn't set too low for ths)
__________________
<?php eval('$post["signature"] = "' . fetch_template('hellcats_sig') . '";'); ?>

Check this:
[ WMail - vBulletin WebMailer || PM-Auto-Reply || Countdown-Timer for signature ] * [ more ]
[ Realtime Page Compressor || The allmighty IRC /me action ]
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 15:48.

Layout Options | Width: Wide Color: