Hi, I recently switched from a shared host with my Joomla site sharing a Mysql server which was dramatically decreasing performance, to a dedicated server with local database connection. The new site is lightening fast as a fresh install. I was then going to transport my database across to the new server. I made a backup via exporting with phpMyAdmin, and imported to my new server via phpMyAdmin. Upon looking at the site, none of the articles had copied across fully. There was maybe a line here or there...maybe a paragraph or so on some articles, but not the full thing (this is not just showing the intro by the way!) So I looked at the copied database table and it is only a third of the size of the original in kilobytes. So I tried to export JUST the table with the content (jos_content) alone...and found the table to be only a third of the size, with most of the articles missing. I contacted my new host and they looked at the old shared server phpMyAdmin and told me the following error is preventing a proper backup of the database. "The additional Features for working with linked Tables have been deactivated" The old host will not activate this setting. I have now started to copy across...manually, one by one, the data contained in the old fields, and manually creating them in the new database. This is a pain staking and difficult task! I then realised I have a HUGE database of registered members (Through Joomla/Community Builder!!!) Does anybody know how this may be fixed - is there any other way to do this or am I stuffed without my old host being able to activate linked tables? If the registered members table exports better than the content table, can this just be imported? Thanks for any help anyone can offer. Andy
try getting around the issue by using lazybackup , a joomla plugin that will backup your db and send it by email o
I have the same problem and the team form ProJoomlaInstall.com find the solution and migrate my database without any data losing .