cheat question

Posted: Wed Aug 10, 2011 2:19 pm

This may sound... "dumb"... Laughing

I'm setting up a test server with a "fresh" install of the lastest RN. Once uploaded and configured, etc., do you think it would be possible to copy over the database with my existing DB? (There are issues with some additional fields, etc. so I'm thinking that only copying/ importing the data into a "standard" distro may "help")

I know there will be issues with some fields in the database by doing this that I'll need to watch for (and I'm thinking of copying my .htaccess file over and making the necessary changes also)

Do you think this is a viable option? (I'm thinking that doing it this way should only give me a few fields I need to edit in the Db)

Comments/ suggestions?

Cheers

Andy

registered · Posted: Wed Aug 10, 2011 7:15 pm

Actually, I would stand up both the "virgin" DB and your "production" DB side-by-side (different DB's but all in the same test server's MySQL instance) and then use MySQLDiff tool to compare the two. You can even have it generate the ALTER/CREATE/DELETE SQL necessary to bring the "virgin" DB up to the same schema.

Rather than just execute that generated SQL as is, I would go through it with a text editor and remove any of the changes that you do not want to make, such as any tables in your current site that are not in the virgin install and that you don't want to have in your final DB.

Hopefully this makes some measure of sense. I'd still get MySQLDiff and run at least the compare and generation of the SQL so you can see what I am talking about. A very useful tool.

Posted: Wed Aug 10, 2011 11:20 pm

Cheers;

I was actually thiking about using MySQLDiff this morning when on "autopilot" on my way into work (late - oops)... I may have used it before, I can't remember. I raised a ticket with the hosts the other day and asked them to copy the files structure and Db over from one domain to the other (on separate hosting accounts)- the "existing" files will be in a folder called "test" so anything that's missing and *may* break the site can be rectified easily. The DB will be named differently to existing, so It should be easier to do the comparison.... (I know that themes is the first thing that will be "out of whack".

Thanks for the "heads up". With any luck I may get my head around this before next week and running so I can star testing...

Posted: Thu Aug 11, 2011 6:39 am

I am going to continue encouraging folks to use your own local PC as a test bed. Tools like XAMPP make this extremely easy and you can very easily run as many copies of whatever you want and never pay for extra hosting or mess with having to constantly FTP files you modify up to your "test" site on the web. Testing locally is the way to go IMO...

Posted: Thu Aug 11, 2011 8:41 am

Agreed. but as i want to test some things that may not work fully in wamp like.htaccess and as i have a reseller account....

Posted: Fri Aug 12, 2011 6:40 am

AndyB, since WAMP has Apache, .htaccess should work just fine. The only thing that might cause you a little grief with a local system is PHP mail(). But, even this can be gotten around by configuring the TegoNuke Mailer and SMTP within the Forums admin. Everything else should work exactly the same.

But, of course, adding an account on the web works too, just makes it more difficult to "develop" on.

Posted: Sat Aug 13, 2011 4:04 am

not if it's locked down Wink

it's on a completely different domain- I'll change the .htaccess robots file to no follow and limit access to a certain "choice" individuals Very Happy

Posted: Sat Aug 13, 2011 6:05 am

err.... is there anyway I can get an 88Mb + file into mysql? Using phpmyadmin has a limit of 50mb.....

I've raised a ticket asking the hosts if they can copy it from one domain to another (couldn't see an option in whm) -and I've had no response from them (as yet)

Posted: Sat Aug 13, 2011 10:07 am

I use BigDump:

http://www.ozerov.de/bigdump/

Others here use other scripts but I've used this one without fail.