[SOLVED] Exporting MySQL database problems.
August 5th, 2016
I am redesigning clients website. They have it on joomla and they wanted a fresh redesign in wordpress. Ok I made it but now here is the problem. They want categories and post imported from online website. I found plugin called joomla to wordpress fg or something like that. But in order for it to work I need have wordpress installed on the same server. I cant do that but I can export MySQL db to my computer and import it locally. now here lies the problem. When I expkrt it via phpmyadmin it exports it partially.
What can I do? Is there any other way for me to export it. Or is there a better way to transfer from joomla to wordpress?
Thanks in advance.
Using plugins of that kind may not be the best option; other than lack of knowledge they are strongly discouraged. They are full of problems and by using them you nearly always condemn you to a lot of maintenance work, especially if they also migrate user informations etc. etc. …
You have to export all the databases to be sure and write a quick script to change the format from Joomla to Wordrpress. It’s a script of less than 20 lines so you don’t need special training. Once the database is fully compatible, you can import it in WordPress and have the posts automatically populated.
https://docs.joomla.org/Copying_a_Joomla_website
You can dump the whole database and fake it on the FG plugin. You can configure the copy of the database as the used one and have the plugin run properly. After this step, you only have to copy the output on the server.
By the way, the conversion is really easy. In my opinion you should try doing a script by yourself. The content is stored in a pretty straightforward way: You will have something like this:
-Title: xxx
-Description: yyy
-Content: zzz
It’s very easy to write a script, you already have the delimiters.
the db is importing partially coz the mysql takes lots of time to import and export the database and there might be an timeout. Try breaking that large dbase in small sizes like 1-5 mb depending on the size of datase you importing.
Try this program, as i have used it to import a database of 15GB successfully.
http://www.rusiczki.net/2007/01/24/sql-dump-file-splitter/
Thanks guys for the replying. I found the best solution. I went to the cPanel and downloaded backup of MySQL db. I have imported it with no problems.
Thanks again for quick replys.