youthman

I just received an error saying one of the tables already existed. Do I need to delete the database and NOT do a WordPress install and just import the old database into the new database? I believe I tried this before and when WordPress loaded, it asked me to install WordPress which would create the additional default wordpress tables with the default wp_ prefix. I wonder if it wouldn’t do that now that I added the custom prefix to the config.php file?

Tara, I figured the original developer did that for added security.

I found this site https://digwp.com/2010/10/change-database-prefix/ that recommends changing the defauld wp_ prefix in the config.php file BEFORE installing WordPress. I just created a new database and changed the prefix from wp_ to wp_m010svz2ny_ and am uploading the previous database to the new server.

I’ve got my fingers crossed!

I just tried deleting the default wp_posts tables from the database and leaving the custom tables (ie wp_mp010svz2ny_posts) but when I try and go to the site, it is wanting me to install WordPress. How do I tell WordPress that the database has these custom tables? I hope that makes sense.

I might be getting warmer……Looking at the database some more, I think this is the problem. If I look in the wp_posts table, there is only the default wordpress sample page and hello world post. But there is also a wp_m010svz2ny_posts folder that has all of the pages from the previous website.

So how do I either remove all of the _m010svz2ny_ from the database or change wordpress to use the _m010svz2ny_?

I’ve been working on this for 12hrs and still do not have a working site. ??

I received the phpmyadmin login information from the previous developer so that I can reexport the database.

One thing I notice is they must have changed the folder structure because each of the tables look like this wp_m010svz2ny_posts.

Would the m010svz2yn part cause any issues if I’m importing that into the site? I wouldn’t think it would. Just trying to consider all possibilities.

Hi Tara, thank you for the reply. Yes, I did look at that document but there isn’t much “detail” on it.

I used the same username, domain remained the same…

I’m now questioning the backup database that was sent to me from the previous developer. When I look in the database table within phpmyadmin and click on wp_post, it only shows the “Sample Page” and the “Hello World”. When I look at the same location on one of my other customer’s wordpress database, I see all of their pages & posts. It’s almost as if the database he sent me was somehow incomplete?

I am literally at a total loss . I have tried everything that I know to resolve the problem . One thing that is interesting when I look at the table for post in the phpmyadnin, it only shows the default welcome to word press and the sample page post . Now I’m wondering if the backup database that was sent to me was somehow incomplete? I’m trying to get in touch with the previous web developer to send me another backup of the site

Ok, I am SOOOO confused. The files just finished uploading through myphpadmin and I received the following message

Import has been successfully finished, 242117 queries executed. (clc.sql)

But when I navigate to https://www.citylifechurch.cc I get just the basic install of wordpress. What am I missing or doing wrong?

I just noticed in myphpadmin that it says, “A compressed file’s name must end in .[format].[compression]. Example: .sql.zip” My zipped file is called clc.zip. Could that have caused a problem? Hopefully now that I’m uploading the unzipped .sql file, it won’t matter and it will finally work. Got my fingers crossed!

Ok, so I created the new database, edited the config.php file with the new database and uploaded to the server.

I went to the domain and it asks me to install wordpress. After I finish the install, I login to the control panel and it’s just the basic site so I log out.

I login to phpmyadmin and click on the new database I just created, then click “Import” and browse to the database backup file and unchecked the “Partial Import” box and hit Go.

In previous attempts, I was uploading a zipped .sql file. This time, I unzipped the file and am uploading the unzipped .sql file.

Will let you know what happens after it finishes uploading.

Question….when I create the new database, which is the best method?

1) Navigate to the install.php file to create the basic website and then go into myphpadmin and import the old database

or

2) Import the old database into the freshly created database without navigating to the install.php file.

And once again, the site is not working.

When I navigate to the home page, Firefox says…

“The page isn’t redirecting properly

Firefox has detected that the server is redirecting the request for this address in a way that will never complete.”

I’m going to delete the database once again and try again.

Now the site appears to be working.

Any reason why the site keeps losing sync with the database info that I imported?

Now when I do a Ctrl+F5 to refresh the browser, I’m brought back to the generic “Hello World” wordpress site.

You have a good point.

The virus has to do with the twitter feed from the theme.

My initial plan was to purchase the latest version of the theme, create a fresh install (not just copy files from one server to another) and create a new database on the new server.

It looks like moving the website will require downtime of the website because I cannot setup the wordpress database until the dns servers are pointed to the 1and1 (the new webhost) since 1and1 shared hosting uses dynamic IP addresses.