Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2008-07-06 23:20:15
- gayleamy
- New Member
- Registered: 2008-07-06
- Posts: 7
Import Wordpress?
My site currently has a blog built through Wordpress; the posts from which I’d like to import into Textpattern (with the future goal of building the whole site in it). When I try to do so through the “Import” tab in Admin, I get:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘essentsn_wrdp1’@‘localhost’ (using password: YES) in /home/essentsn/public_html/gayleamy/home/textpattern/include/import/import_wp.php on line 7
AND:
*max_execution_time = 330
WordPress database values don’t work. Go back, replace them and try again. *
I have NO idea what could be wrong here: all of the information is correct, and the document path above is for the TEXTPATTERN directory, not for the Wordpress one… And so I don’t understand how the access would be denied for that; if the database values were wrong, wouldn’t it deny access to the other directory?
My other question is if it makes more sense to avoid all of this entirely by exporting the db to a file in phpmyadmin instead… But then to what type of file; and how would I then import it to Textpattern?
Please help – my MySQL understanding is pretty much limited to the creation of the databases for the installation, and the occasional backup…
Offline
Re: Import Wordpress?
That first error means that you entered the wrong username/password/database combination while importing Wordpress data from within the Textpattern import tab.
Offline
#3 2008-07-07 20:54:55
- gayleamy
- New Member
- Registered: 2008-07-06
- Posts: 7
Re: Import Wordpress?
Thank you for your response.
I assumed that’s what the error message means, but I’ve double-checked all of this information with my hosting company, and it’s all correct… For the Wordpress installation in question:
The MySQL database name is: essentsn_wrdp1
The MySQL user name is: essentsn_wrdp1
The Password to the database is: ******
In the Textpattern Import for Wordpress, I’m selecting Wordpress from the drop-down and entering:
Database Name: essentsn_wrdp1
MySQL User: essentsn_wrdp1
MySQL Password: ******
MySQL Host: localhost
Table prefix if any: wp_ (Which is the default)
Am I entering these values incorrectly?
When I do all of that, I get the error message above, and… I can’t imagine what is wrong; “******” is the password for EVERYTHING in that account.
Could there be any kind of issue because the website I’m working with is an add-on/subdomain (it’s gayleamy.com, but the main domain is essents.net; therefore subdomain: gayleamy.essents.net)? Is there any issue because I have Wordpress in a sub-folder in my account… And Textpattern is in a sub-folder as well…?
And, again – is there any way to just bypass this automated import, and EXPORT the database through PHPMyAdmin to some type of file, and then import it into Textpattern that way?
Thank you so much for your assistance… I’m just completely at a loss as to what could be the problem here.
[Ruud: removed the password, just in case it was the real one]
Last edited by ruud (2008-07-07 21:30:55)
Offline
#4 2008-07-07 21:12:15
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,306
Re: Import Wordpress?
Hope these are all dummy values ;) Don’t forget to change them when you go online!
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
Re: Import Wordpress?
Are you sure MySQL Host: localhost is correct?
Piwik Dashboard, Google Analytics Dashboard, Minibar, Article Image Colorpicker, Admin Datepicker, Admin Google Map, Admin Colorpicker
Offline
#6 2008-07-07 22:49:35
- gayleamy
- New Member
- Registered: 2008-07-06
- Posts: 7
Re: Import Wordpress?
Well, no MattD… I’m not.
I’ve tried it as essentsn_wrdp1@localhost – which is what shows up in the error message – and essentsn@localhost… Nothing works. Is it possible that it could be incorrect, and if so, what would be another option?
localhost is just always the default value and has worked in every situation involving MySQL databases in the past.
Offline
#7 2008-07-07 22:53:06
- gayleamy
- New Member
- Registered: 2008-07-06
- Posts: 7
Re: Import Wordpress?
Also…
Does anyone know of a way to do this manually as I mentioned; export the database to a file (as done in backup) and then import THAT into Textpattern?
I’ll just do that if that’s possible, because it’s getting ridiculous and frustrating trying to make this method work.
Offline
Re: Import Wordpress?
It’s either the wrong database name, the wrong user name or the wrong password.
Have a look at your /textpattern/config.php file. That’s how you’ve set similar values for textpattern. Perhaps that helps to find the correct values for importing.
Offline
#9 2008-07-09 06:55:22
- gayleamy
- New Member
- Registered: 2008-07-06
- Posts: 7
Re: Import Wordpress?
Thank you for that suggestion, ruud – it led me to check the Wordpress config file, and… Indeed, the password was some gibberish which must have been generated when WP made the database. Frustrating, because it’s not been the case with any other MySQL databases I’ve worked with.
Thank you so much for your help!
Offline
Pages: 1