Copying MySQL database

[rami]

hello there,
i have vB but it's a little old...
so i just want to upgrade this forum..

so..how can i copy a database from the old forum and import it in the new one ?!

anyone have idea ?!

[rami]

and also i just want to say that my database that i wanna copy is about 300 MB !!

so is there a way to copy it from the same server to it again ?!

i hope that someone understood me !!

i mean to backup the database ... but to put the backup to the server without download it to my PC and then upload it again !!!

thanks

[redsox9]

I would check the software literature to see if there are some simple steps to take. It may be as simple as installing the new software and pointing to your old databases.

[rami]

I would check the software literature to see if there are some simple steps to take. It may be as simple as installing the new software and pointing to your old databases.


I hope that u get what i mean !!

to backup a 300Mb database without install it on my PC...
it's just copying the database on the server and paste it again !!!:confused::confused:

[dataman]

to backup a 300Mb database without install it on my PC...
it's just copying the database on the server and paste it again !!!


Based on the above, you want to do a backup of your database to say, another directory on your web server. Here's one approach:

1. Using the File Manager in the C-Panel, create the folder that you want to hold the contents.
2. Go to phpMyAdmin and access the specific database you want to backup.
3. For each table, do an export. It is recommended that you utilize backing up both the structure and content. The destination for this backup will be the folder you created above.

If this is the only database that you have on your account, a much easier option would be to use the backup option in the C-Panel and backup your MySQL databases to the destination folder created in #1.

Hope this helps.

DataMan