Topic: How to backup a database to import to another database on another host
This is my very very big problem. It may cause me to leave my punBB forum and choose to set up a non-MySQL forum. It's disastrous because I like my punBB forum.
My 1st host:
- Domain: abc.com
- Has a punBB forum
- A MySQL database name: a1111_punbb
- The database's user and password are: a1111 and 123456
- MySQL host name is xxx.abc.com
Now my host is crashed and I must move the forum and its database to another host (2nd host). Also I change my domain.
- Domain: def.com
- MySQL database name: b3333_forum
- The database's user and password are: b3333 and 123456
- MySQL host name is xxx.def.com
Please help me answer these questions:
1/ What do I need to do to back up my MySQL database "a1111_punbb" at "abc.com" (1st host)?
2/ Then how to import that back-up file to my new database "b3333_forum" at "def.com".
3/ I think I must change something in the back-up file, also. Because my new database will have a new name; it'll be on a new host and a new domain,...
I've tried to export my "a1111_punbb". It creates a .sql file. Then I've tried to import it to my "b3333_forum" but it keeps displaying errors about missing parameters, invalid,... or something like that.
It makes me go crazy! Now I'm very afraid that one day, if my host crashes and I need to move to another host, I can't bring my MySQL database with me and all posts, replies in my forum will be lost.
Thank you very much.