Here is what I need done. I need to back up all my Databases with my webhosting company first. I think PHPMyAdmin I might be able to do it with that because I do not have root access to the MySql servers. Second after I back up and save these databases I need to copy them to a CD and have the Databases renamed to what I want the i.e. Database001, Database002, etc. The first problem is hat some of these databases have multiple users with tables from other programs. I need to "weed out" these various user tables into seperate databases and eventually put them in their OWN respective database. I did it this way originally because my hosting company only allowed 5 databases but I had 15 programs requiring MySQL.

Second, I need to Create a MYSql box at my house and import these 5 databases, into their 15 new databases so all the programs have their OWN database. I have NO CLUE on how to create the databases and thn import program specific database tables into those DBs.

Finally, on a few of those DBs the programs used an OLDER version on MySql (3.23) and I want to install the newest version of MySql. So how will these DB tables import into the new MySql... does anyone foresee any problems? They are VbBulletin DB's (The Site example is http://www.100spot.com/forums)


Any help to get started and the correct commands would be greatly appreciated. Whoever knows this stuff must be a MYSql Genius!

Thanks in advance!

The "mysqldump" utility creates a backup as a file of SQL commands that you can execute to recreate the structure and data of your databases:

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Obviously, once you have such a file you can copy parts of it to another file to make up a SQL script that recreates just specific tables (for example).

Since mysqldump is just a command-line utility you can use it in shell scripts in conjunction with any other utility to do things like batch downloads and renames of the backups that are created. If you haven't worked with shell scripts, it takes about an hour to learn with the tutorial here:

http://www.linuxcommand.org/

Great, I will start looking into thsi stuff. Much appreciated my friend.

Problem here I foresee is not having terminl access. The DBs are created via a web interface on a shared host therefore not allowing me to do anything via terminal, shell, or root. In a sense it is a "virtual" or "shared" server.

PHPMyAdmin has done the trick... as far as the backing up part. The Restoring part on a new MySQL server will be the task I have to tackle next.