Posts Tagged ‘Database moves’

Moving Databases

Saturday, August 6th, 2011

I got the new hosting space. There was a problem with FTP at first but that cleared eventually. I uploaded my article directory site to the new server. I had been concerned about the time that it would take because of the size and the download time that I had experienced, but the upload time seemed to be about the same if not slightly faster than the download.

The real battle here has turned out to be the moving of the database. There is a synchronize function built into phpMyAdmin that should do the job if I can figure out the right data to fill in the blanks. I have done web searches and looked at the phpMyAdmin documentation, but everything that I have found is above my level. If I don’t find something that I can understand maybe I will write something up (before I learn enough so that what I write will be above a beginners head).

I looked things over and saw export and import options and thought that things would be easy. These seem like they would work fine with lighter weight databases but there seems to be about a 50 MB limit and my database that I need is over 250 MB. I had thought of a possible work-around, but it was going to be a lot of work, and this is just the beginning as I will need to move a couple of other sites to the new space as well.

While poking around in phpMyAdmin I noticed a synchronize tab. I investigated and it sounds like it will do what I need to do. There are some settings that are a bit unclear so I will need to gather a bit more information. I may even need to make a couple of calls to support as the new space is with a different hosting company.

Stay tuned for another episode in the saga of the great website transfer, soon! As soon as I get this working I will even give you the new address (link) so that you can check out my labors and see if you can find any problems.


privacy policy | terms of service | about us