Importing a database

[bikerdave]

Folks, I have my forum database on another host. I cannot export it using phpMyadmin because it times out. The db is 13Mb in size.

I've used SSH to dump the db on the other host but I read in the powweb FAQ's today that powweb doesn't support shell programmes.

Any suggestion on how I could import the database into powweb. I don't think phpMyadmin can read the way the db has been saved, when I used mysqldump. :(

[tbonekkt]

I believe MYSQL-Front would work for this.

[bikerdave]

Originally posted by tbonekkt
I believe MYSQL-Front would work for this.

Thanks tbonekkt, I hadn't known about that one, I'll give it a go. :cool:

[bikerdave]

tbonekkt, that seems to be working.

there's a little problem with getting it to overwrite data in the tables, rather than just adding it but I'll work on that. :cool:

[tbonekkt]

I actually use another program as well - SQLyog. Try it here: http://www.webyog.com/sqlyog/

[HalfaBee]

I wrote a little script for big imports, it uses mysql directly and is very quick.

http://forum.powweb.com/showthread.php?threadid=20022

HalfaBee

[bikerdave]

Originally posted by HalfaBee
I wrote a little script for big imports, it uses mysql directly and is very quick.

http://forum.powweb.com/showthread.php?threadid=20022

HalfaBee

Thankyou, I will give that a go. :cool:

[bikerdave]

Originally posted by HalfaBee
I wrote a little script for big imports, it uses mysql directly and is very quick.

http://forum.powweb.com/showthread.php?threadid=20022

HalfaBee


HalfaBee, you are an absolute star. That worked a treat. :cool:

My importing hassles are over. :D

[HalfaBee]

Not a problem.

Happy to hear it worked ok.

HalfaBee