How do I restore my SQL database on my own server?
 

This is a simple question I have but I do not know how to do it. I run my own server out of my home and I am simply wondering how I restore my vBulletin MySQL database. I tried to using phpmyadmin but the file is so huge it timesout after like 30 seconds. Since this is my own server I obviously dont need to use Telnet so I am wondering how I go abotu restoring this. I would really, really appreciate it if someone could give me a step by step walkthrough as I am not to knowledgeable with programming code and DOS and what not.

Thanks!
Chris

phpmyadmin crashes out after 1.5 meg (cant handle files any bigger)

If your host allows outside connections use this program

MYSQLFRONT - (put name into google cause its listed everywhere)

now enter username and pass /ip and database name and you can export it to your comp or import it.

If you are running the server on your comp then still use same program - does the job just as good except your ip will be localhost.

LInk - to mysqlfront

http://mysqlfront.venturemedia.de/in...t=ST&f=2&t=328

let us know how u get on

Since when? I've uploaded a db that was just under a gig. It took a long ass time but it still went.

@EVO VIII Chris What OS are you useing?

Im using Win 2k

How did you manage that? phpMyAdmin always times-out

So what exactly does MySQLFront do since I am having a hard time understanding what exactly it does that phpmyadmin doesnt. I dont even know why they call it phpmyadmin it seems like it has nothing to do with php anyways. Well does anyone know perhaps if there is just a way for me to do this via DOS or something instead of having to DL a program, Ive got way to many programs on my computer its to hard to keep track of them all.

Chris

you cant upload 1 gig using phpmyadmin

i dont claim to know much and was only offering my help in here and mysqlfront is a top program but i have never heard of phpmyadmin doing 1 gig files LOL its total crap for anything but the basic stuff

Edit

well i suppose you could do it if the file was cut into different smaller sizes but are we talking 1 gig 1 file ?

also mysql is so easy m8 if you cant be bothered to download it then its your loss.Ive used it from day 1 since someone recommended it to me and now im doing the same.You want things that are easy well theres your choice.