Topic: How to move installed punbb to another hosting?

How to move installed punbb to another hosting?

~About the PerFect Things~

Re: How to move installed punbb to another hosting?

Do you have access to a database administration tool such as phpmyadmin?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Re: How to move installed punbb to another hosting?

I have shell access, phpmyadmin, ftp, almost everything.
Can i backup the databse using mysqldump command from shell?

~About the PerFect Things~

4 (edited by Fredrik 2004-09-20 18:34)

Re: How to move installed punbb to another hosting?

hyapadi wrote:

Can i backup the databse using mysqldump command from shell?

That's what I want to know too. If I can backup the database and then move it to another machine and import it... with success?

Would "mysqldump --all-databases" make a backup of all my databases which I later can move to another computer with mysql and from there import it all again?

Re: How to move installed punbb to another hosting?

can't you just upload phpmyadmin?

Re: How to move installed punbb to another hosting?

hyapadi wrote:

I have shell access, phpmyadmin, ftp, almost everything.
Can i backup the databse using mysqldump command from shell?

Yes, it's no problem. Use something like this (ask google first, I'm not sure of the syntax):

mysqldump.exe -uroot -pmypasswd mydb > dump.sql
mysql.exe -uroot -pmypasswd mydb < dump.sql

Re: How to move installed punbb to another hosting?

I recommend using mysqldump with the switch --opt. It makes the dump a bit smaller and speeds up the importing of the dump.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Re: How to move installed punbb to another hosting?

Connorhd wrote:

can't you just upload phpmyadmin?

For big databases, pages can time out when dumping through phpMyAdmin.

9 (edited by Fredrik 2004-09-20 19:45)

Re: How to move installed punbb to another hosting?

in windows can i run this?

"mysqldump --all-databases > dump.sql"

i don't know how to do. i ran "mysqldump --all-databases" and it took like 2 minutes maybe. i've got not that big databases. but im guessing this dump didn't get anywhere but on my screen? so i added "> dump.sql" and got an 18 mb file. can this be right? it went really fast. is it ready to be imported into another computer?

Re: How to move installed punbb to another hosting?

It sounds correct, and yes it's that fast :)

It's ready.

Re: How to move installed punbb to another hosting?

Thanks! This sure helped me. I hope hyapadi got use of it too, since it was his post. wink

Re: How to move installed punbb to another hosting?

Oh wait.. still one problem. Can I really import a dump like this (all databases)? If so then how? I can't seem to figure it out. sad

Re: How to move installed punbb to another hosting?

Try:

"mysql < dump.sql"

Note that it's a <, not a >.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Re: How to move installed punbb to another hosting?

Frank H wrote:
Connorhd wrote:

can't you just upload phpmyadmin?

For big databases, pages can time out when dumping through phpMyAdmin.

lol my websites never get more than a few thousand posts before i break them so i wouldn't know wink

Re: How to move installed punbb to another hosting?

I know.. the general way to move
1. backup database > restore it @ new hosting
2. move the files to the new hosting
3. change the config for the path <--- this what I want to know tongue

Any ideas?

~About the PerFect Things~

Re: How to move installed punbb to another hosting?

Connorhd wrote:
Frank H wrote:
Connorhd wrote:

can't you just upload phpmyadmin?

For big databases, pages can time out when dumping through phpMyAdmin.

lol my websites never get more than a few thousand posts before i break them so i wouldn't know wink

lol ... well the attachment mod can make some huge databases wink (mine is over 300MB wink)