SQLSTATE[HY000] [2002] No such file or directory

  • Resolved editor4alan

    (@editor4alan)


    2 years, 2 months ago

    Hi. I need to copy content from https://www.southmountainmemorycare.com/ to https://southmountainmemorycare.tempurl.host/. I copied the following from the Joomla site to the WordPress site but get this error message when testing the database connection: SQLSTATE[HY000] [2002] No such file or directory.

    public $dbtype = 'mysqli';
	public $host = 'localhost';
	public $user = 'smtm1540_jos1';
	public $password = 'X(e7g]xyX(wjGc79wO(54((2';
	public $db = 'smtm1540_jos1';
	public $dbprefix = 'jos_';

    I keep the Port at the default 3306. What file or directory is the plugin looking for? Thanks!

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Kerfred

    (@kerfred)

    If Joomla and WordPress are not installed on the same host, you can do this:

    • export the Joomla database to a SQL file (with phpMyAdmin for example)
    • import this SQL file on the same database as WordPress
    • run the migration by using WordPress database credentials (host, user, password, database) instead of the Joomla ones in the plugin settings. You can find the WordPress credentials in the wp-config.php file.
    Thread Starter editor4alan

    (@editor4alan)

    Hello Kerfred,
    Thank you for your suggestion. However, phpMyAdmin is not available on the site or in GoDaddy. I looked into installing it on the site but, honestly, after researching it, I admit the procedure is much too complicated for me. I may have to rely on hours of copy and paste to move the content over. Thanks again!

    Plugin Author Kerfred

    (@kerfred)

    Normally all providers provide phpMyAdmin. It is not normal that your provider doesn’t provide it.

    Thread Starter editor4alan

    (@editor4alan)

    I had a terrible time with GoDaddy chat before they pointed me to it. I was able to export the db as SQL. Perhaps you can answer another question for me. I have created a new site in WP and have worked on the home page. If I import the Joomla db, will I lose the new home page?

    Plugin Author Kerfred

    (@kerfred)

    It won’t delete your existing data, except if you select the automatic removal checkbox.
    I strongly advise you to make a backup of the WordPress database before doing anything.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘SQLSTATE[HY000] [2002] No such file or directory’ is closed to new replies.