UBB.Developers Forums Community Development Programming MySQL and Server Configuration Duplicate my DB

I want to duplicate my DB and use it for my beta site using 6.5 what is the best way
to duplicate my site? and upgrade it/ or do a fresh install with old db?

I just want to play around offline w/ a dupe, I need to add some mods back in
and can't go live till I figure it out.

I used phpmybackup to backup my db, then I went in and did some renaming so it would create a new db instead of overwriting the old.

The only renaming i see is if i open the file that i downloaded there is a database name All i have to change is that to something other?

change any and all occurences of the GOOD database to the NEW database name and that will create a duplicate with the right name.

Ok I have php/mysql and phpmyadmin installed on my local machine i have downloaded my databases via my vertexthost CP and via the ftp from a backup, and via phpadmin.

I cannot seem to figure out how to get my local version to import this data?! non of the version I download do anything...

OK - on your live database - do a MySQL Dump (the Export tab in phpMyAdmin) and download the file to your computer.

Then create a new database - then using phpMyAdmin, select SQL and click "Browse" to select the file from your computer. That'll upload and reimport this to the new database.

If you'd like Vertex to duplicate your database for you - Open a Ticket with the name of the database you want duplicated and your Cpanel login info and we can do this for you if you're stuck.

is there a way to do it without downloading and reuploading? I would like to get the new beta a run too

It can be done at a command line using the mysqldump command.


To dump the db:

mysqldump dbname -u username -p > dump.sql


To restore the db:
mysql newdbname -u username -p < dump.sql


there are more details here:
http://www.ubbcentral.com/support/docs/ubbthreads/UBBthreads_backup_transfer.html

The instructions are slightly incorrect - or should I saym I can't get the syntax to work as stated.

The instructions say...

mysqldump –u username –p=password databasename > filename.dump

mysql –u username –p=password databasename < filename.dump


But the method I use is...

mysqldump -u username -ppassword databasename > backup.dump

mysql newdatabasename -u username -ppassword < backup.dump

Which is similar to the code that Josh wrote above - but the '=' before the password will error out as mentioned in the documentation.

on my local machine in phpmyadmin next to the browse button
the max file size says (Max: 2,048KB) my databases is over 100mb.

how do I change this?

also on my local machine in terminal I can't execute the mysql statement I remember something about symbolic links and have searched for my notes but cant seem to remember the method of getting it to work.

Still trying. I would very much like to get this running on my local machine so I can save bandwidth. And space on the server.

If you can't do it via the command line or phpmyadmin - then you could always backup using the internal backup tool within threads - install a test copy of the same version of threads - change the database details to the new one - and restore the database.

Can't see why that shouldn't work

Well i had to break down and RTFM so far so good. i will keep you posted !

I did it! got the board to install correctly. And upgrade with only a few hiccups.
I even managed to apply a few hacks back. 6.5 has been worth the wait!

Glad to hear things are slowly working themselves out.