installing 3 differnet wordpress for 3 different domain in one hosting service

Exactly what isn’t working? From your post it sounds like you have everything ready and set up, so it’s hard to tell where you’re having an issue at this time.

the question is how i can import or copy my zip file to my current(new) domain and how i can import the database in ipage.com

Have you reviewed Moving_WordPress?

no, ok let me read through it and see if got stuck.

thanks brother

i am little Confused reading the above link,

let me know if this step is good.

1- Create a database and import old side databse into it.
2- unzip the old wordpress site. (All of it)
3- replace all the Content from old wordpress site to new site.

anything i am missing friend

when i am uploading the Database i am getting this

——–

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: i208690_wp11
—
— ——————————————————–
—
— Table structure for table wp_commentmeta
—
CREATE TABLE IF NOT EXISTS wp_commentmeta (
meta_id bigint( 20 ) unsigned NOT NULL AUTO_INCREMENT ,
comment_id bigint( 20 ) unsigned NOT NULL DEFAULT ‘0’,
meta_key varchar( 255 ) DEFAULT NULL ,
meta_value longtext,
PRIMARY KEY ( meta_id ) ,
KEY comment_id ( comment_id ) ,
KEY meta_key ( meta_key )
) ENGINE = InnoDB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;

MySQL said: Documentation
#1046 – No database selected

this database other developer gave it to me.

can i get some help.

thanks

the other thing what i did is as my domain is the same and hosing is with different provider, other means is i transfer my domain to other hosting company. so i copies everything from my computer to new hosting company and left .htacess and wp-config file. when i am trying to import database i am getting error mentioned above, and when i am trying the address its not getting the site, am i missing something

please help

You don’t need to change your domain to the hosting company. That makes no difference.

MySQL said: Documentation
#1046 – No database selected

That error tells you what’s wrong. You need to select a database before you run the import. If you’re uisng phpMyAdmin you need to click into that database and have it say ‘No tables’. If you’re using the command like you can use the MySQL command to select the database. After that run the import.

hell there i started from scretch and created a database and import the dataabase sucessfully, than copied all the WordPress Files in the hosting domain. and change the wp-config file according to the databsae i created. Now when i am tying the address it saying that”Error establishing a database connection”

and

when i am going to mydomain.com/wp-admin, it saying…

Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at https://mydomain.ca. This could mean your host’s database server is down.

Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?

what i am missing. please help

You obviously havn’t got the DB connection details correct. The error message tells you exactly what the problem is. Make sure that you check everything – and remember that the DB server is normally ‘localhost’ and not your domain as some servers will block MySQL connections from outside, which is what your server would be trying to do. You should check with your hosting company to make sure that it is if that’s the only thing that you aren’t 100% sure about.

i got it fixed, thanks for all your idea, i just want to explain for some of my friend how are hosting from ipage,
ipage would not allow you to use either IP address or LocalHost in your config file, you have to go the database and look on top of show called SERVER: xxxxxxxxxx this is what you ahve to put on your DB-Host in your wp-config file and than good to go.

thanks again