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 2004-09-20 18:18 (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?
- Connorhd
- Former PunBB Developer
- Offline
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.sqlmysql.exe -uroot -pmypasswd mydb < dump.sqlRe: 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 2004-09-20 19:44 (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. 
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. 
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."
- Connorhd
- Former PunBB Developer
- Offline
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
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 
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
lol ... well the attachment mod can make some huge databases (mine is over 300MB )