The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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
|
#2
|
|||
|
|||
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. |
#3
|
||||
|
||||
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. Code:
mysql -u root -psecret -D stocks2 < stocksdb.sql |
#4
|
|||
|
|||
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)
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|