WordPress.org

1. hackercompany
   Member
   Posted 5 months ago #

   Hey all I am having a bit trouble with my sql. I have seen some alien IDs logging into hosting account so I decided to shift my wordpress.

   What I am doing is I installed wamp on my windows Xp computer and then installed a wp 2.8 in it. I then configured the wp-config file and added all the specifications of my hosting's wp-config file but changed the value for db_host from localhost to my domain LIKE
   

   /** MySQL hostname */
   define('DB_HOST', 'localhost');

   to

   /** MySQL hostname */
   define('DB_HOST', 'www.technodesi.com');

   I think it is the right way to do this but still it shows me an error Error establishing Connection with database.

   So can any one find a problem in this as I am totally confused !!!!!

2. fldtrace
   Member
   Posted 5 months ago #

   First you need to go in phpMyadmin, create the database with the same name with one located on your hosting provider. Create the username and password, to match that from your hosting provider and grant privillegies to that database.

   Now your config file has something to point on.

   But wait, is not done yet.

   Before importing into new created database, the mysql dump file, you have downloaded from your hosting provider, make sure you open it up in Dreamweaver or a speacial software that reads mysql files, and using mass search and replace, make sure you change the links to point to to your wordpress local installation, so:
   http://yourdomainname.com/
   will become:
   http://localhost/path_to_wp_installation the root path to installation, starts in www folder from waamp.

   If something wrong, check you .httacces file to see if points correctly there. You can even delete it, as it will be recreated when you go in permalink structure from wp-admin.

   When you move it to the new host, you have to repeat the procedure.

   Good luck.

3. metamorphyk
   Member
   Posted 5 months ago #

   Could you just go to /wp-admin/export.php and export your wordpress content> save locally. Install new wordpress using fantastico and then import the file you save localley /wp-admin/import.php

   This is by far the easiest method

   BUT

   in answer to your question, you can't use 'www.technodesi.com'as the local host. It is asking for an IP address.

4. hackercompany
   Member
   Posted 5 months ago #

   fldtrace what you are telling is how to import the website to my localhost but thats not what I want. I want my website to run on web

   just that I want my wp to be installed on my system and connect it to my host sql server so that even when I write a post in my localhost it shows up at my website on the internet!!!!!

5. whooami
   Member
   Posted 5 months ago #

   so you want to connect to a remote mysql database?

   1. find out if your host allows it.

   2. then as them what IP to use

   what you pasted above is NOT correct.

Reply

You must log in to post.