TOPIC: Importing directly from Wordpress.com

How would I go about importing a phpmyadmin database when the people who host my clients site at wordpress.com do not give you access to that. They just give her the hosting and nameservers for her domain. This presents a problem in which I cannot get the database files and such. I can, though, export the XML file, but without the database, it wouldn't work. Please help me out. If this will work out, we will buy the product. Thanks!

Well, if you have the xml file, then you can import in phpmyadmin (there is a function to import from xml). Once it is in phpmyadmin -> it is in mysql format so you should be able to use the extension.

Kind regards,
Daniel

P.S. I haven't actually tested that myself and this is the supposed way I think it should work

So, I would only need the XML file that I can get from the backup section of WordPress.com? I wouldn't need anything else? I would just import the XML file into the phpmyadmin of the new site. Are there any steps after that point that change from the guide? And, where in the content section do all of the posts go to the articles database?

I bought it and when I tried to upload the XML file, there was an Error in the database it said.

Server: custsql-ipg09.eigbox.net Error There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem[code]
Server: custsql-ipg09.eigbox.net
Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

Hey Christopher,
Please first do me a favor. Import that xml file into phpmyadmin. Do you see tables such wp_users or posts, or postmeta? Do you see those tables after the import. If that is the case, then there is no problem using cmigrator. It should be able to migrate the tables. Just create a cmigrator config with the proper table prefix and click the migrate button.

Cheers,
Daniel

Can you send me a copy of the file to This email address is being protected from spambots. You need JavaScript enabled to view it. ?
Thanks!

Daniel Dimitrov wrote: Can you send me a copy of the file to This email address is being protected from spambots. You need JavaScript enabled to view it. ?
Thanks!

Sent to you.

I've send you the sql file -> import it in your joomla database. Please also use the latest version of cmigrator: compojoom.com/downloads/developer-releas...-stuff/dev-cmigrator

I've fixed few bugs in it today. I tested the import into joomla on my localhost and it worked well, so it should work for you as well.

Here is what I did to transform the .xml to .sql.
I installed wordpress locally, then went into the backend -> import -> import from wordpress.org -> installed the plugin -> provided the .xml file -> it imported it. Then I just went over to phpmysql and exported the database.

Cheers,
Daniel

I now received this error in phpmyadmin

Error

SQL query:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

--
-- Database: `wordpress`
--
--

---

--
-- Table structure for table `wp_commentmeta`
--
DROP TABLE IF EXISTS `wp_commentmeta` ;

MySQL said: Documentation
#1046 - No database selected

you need to select a database first and then run the import

Select the joomla database and then click on the import tab.

daniel

I'm in phpmyadmin for the Joomla database that I'm on. I just do not see what I should put it under.

you see the path at the top is just server. Click on jml_ndk5....(67) and the path should change to server ... database ... . Then click on the import tab.
Regards,
Daniel

It did not import any of the comments, but everything else worked fine.

Cmigrator can import comments only in compojoomcomment. If you don't have compojoom comment installed on your site it won't import any comment.

Kind regards,
Daniel