var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
DB Restore Help
I need some help.
I've got a vBulletin database to restore
Its about 30mb
Well yeah I started a restore from phpmyadmin AGES ago so I've got bored and I want more options.
Its stored on my server but I chose upload. Is there code that I can use in the query box to use the sql file stored on the server? Would this improve speed?
I've tried to google it and tried hunting through a sql book of mine that I've yet to read - lol had it for like a year.
Is there a script that would do this for me faster?
Thanks for your time and have a great day!
If you have shell access it is quite simple.
$ mysql database_name < /path/to/your/sql_file.sql
You may have to use the -u and -p options to specify your username and password... Type $ mysql --help for more options.
Thanks for the reply
I do not have shell access unfortunately.
Any more ideas?
You can also break apart your sql file into multiple files and use phpmyadmin to upload it in sections.
For example have file1.sql that contains the structure of the database. Then create file2.sql, file3,sql, etc up through file31.sql each containing 1 mb of insert queries.
Is there an app that will do this for me or do I need to understand the code enough to break it apart?
Tee hee its still uploading must be about 2-3 hours now.
You can use:
Its a good app, i use it to backup/restore mysql. Try it and tell me how u like it. Works better then phpmyadmin because you dont have a file upload limit, and you dont have to fool around with php. I dont know if u can use it if you are not a server admin though...
Thanks a lot I'll give it a go ;-)
This script comes in handy and is free ww*.ozerov.de/bigdump.php
Unfortunately it wont allow me access :-(
NextGen Im downloading it as we speak.
Thank you so much that script is amazing.
It sorted the database in seconds.
Thank you thank you thank you.
Thanks again ;-) and have a great day!