I exporting the SQL database (with all tables selected) from thewebpreneur[dot]ca domain, renamed it, and imported it as a new SQL database on my host server. I then installed Wordpress 2.7 through the one click installation feature to the new domain I want everything transferred to, thewebpreneur[dot]net and selected the existing (new) database in the setup, which I exported from the .ca domain, and nothing!.. my posts, comments, theme, etc. are not appearing on my .net domain What did I do wrong, isn't this the right method to transfer all your Wordpress content to a new domain note: the current version in my .ca domain is Wordpress 2.6, but I don't think that matters
One Click Installation Do you mean through fantastico? Then you need to manually edit wp-config file with the database name, username, and password into which you drop all the tables from your previous domain. alternatively, - export the old sql (check drop if exist) - go to your hosting panel and database manager (phpmyadmin) - drop all tables / run sql / import into the new database created by "one click install".
not through Fantastico, I'm with Media Temple, they have their own one click installation feature so in the alternative method I create the database first through the one click installation of Wordpress, then import the tables from the (old) database of my .ca domain and import them into the new database of my .net domain? wouldn't that just result in the same thing from what I did in my first attempt
no. from what I've read (i maybe wrong in interpreting) Before what you did was: - Did one click install, which generate database, username, and password for you. say: data1, user1, xxxx respectively - You've also created your own new SQL database, username, password and imported the old SQL. say: dataN, userN, xxxx That case, your one click install is pointing towards its created data1, user1, xxxx not to your dataN, userN, xxx And you have to edit your wp-config to point to dataN instead of data1 database values. OR alternatively: -after one click installation, go to SQL manager and import old SQL into data1 database (in our example, data1 database is auto created by one-click software) - That way, no need to change wp-config values because your config file's already pointing towards data1 database. You've just "updated" the database by importing "new" tables from old SQL. Edited: Did one click install ask you which database you want to associate with the wp installation? No right? (I'm not famliar with Media Temp thats why). That case, both options above apply.
one click install did ask me which database I wanted associated with the wp installation, but I've tried that also, I selected the existing database (of my .ca domain), but nothing transferred to the .net domain do u want to do this for me, I will pay u, basically I just want everything transferred from my .ca domain to my .net domain (posts, comments, pics, plugins, etc.. everything) I will create a temp. technical user account, PM me ur email and how much u want, payment will be made via paypal after task is completed
I can do it for free and have PM-ed you yesterday. If you wish to continue on your own or if anyone else's wondering how-to, I've also written a thorough guide as best as I can: Transferring Wordpress Blog: Moving From Old to New Host & From Old to New Domain Added: it just sparks. You have to edit the table values of your old SQL, which specify domain name. See changing those works: Step 12-15 on my guide.
my host actually offered to do it for me, I guess I got annoying after contacting them numerous times through support lol I'll PM you back if their attempts are unsuccessful as well