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

[EVO VIII Chris]

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

[lasto]

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/index.php?act=ST&f=2&t=328

let us know how u get on

[SmEdD]

Today at 02:26 PM lasto said this in Post #2 (https://vborg.vbsupport.ru/showthread.php?postid=431028#post431028)
phpmyadmin crashes out after 1.5 meg (cant handle files any bigger)

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?

[EVO VIII Chris]

Im using Win 2k

[assassingod]

Today at 07:41 PM SmEdD said this in Post #3 (https://vborg.vbsupport.ru/showthread.php?postid=431035#post431035)
Since when? I've uploaded a db that was just under a gig. It took a long ass time but it still went.


How did you manage that? phpMyAdmin always times-out

[EVO VIII Chris]

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

[lasto]

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.