Moving WP; stuck at step 2

The themes and plugins folders are typically in the wp-content folder so from your ‘test bed’ system get a copy of those folders, then use FTP to upload those folders to your host.

Yep, they’re uploaded but I can’t find them in the dashboard.

But is that all I needed to do before moving the DB? I guess I just wanted to make sure I wasn’t doing anything in the wrong order.

Thank you sir!

Yep, they’re uploaded but I can’t find them in the dashboard.

Make sure you’ve got files loaded in proper place, check permissions.

But is that all I needed to do before moving the DB? I guess I just wanted to make sure I wasn’t doing anything in the wrong order.

Assuming you’ve used Fantastico to install WordPress, and you’ve done step 1 “If you have changed domain, edit the backed up database file to reflect this…” then importing the database backup via phpMyadmin would be proper to get the data in place.

Also consider asking your hosting company for help.

Make sure you’ve got files loaded in proper place, check permissions.

Okay — in the proper place for sure. Do the permissions need to be 777? And for which files specifically? I also saw something about the .htaccess file; do I need to check anything there?

As for the rest, yes done all of that, thanks!

Some host situations may need you to set your file permissions and make your wp-content, wp-content/plugins, wp-content/themes folders to 777. Sometimes the same needs to happen to wp-content/uploads.

Also update your permalinks in Settings->Permalinks.

Definitely getting there! This has taken care of step 2.

However, now some odd things are happening. I successfully logged out between activating the theme and then uploading the plug-ins, but when I tried to log out after activating them, I got the following message:

Warning: Cannot modify header information – headers already sent by (output started at /home/tekni2/public_html/wp-content/plugins/cforms2/cforms.php:2) in /home/tekni2/public_html/wp-login.php on line 302 […]

That repeated for 17 different line numbers.

So I thought, fine, I’ll try to update the database and see what happens. I went in through phpMyAdmin as described at https://codex.www.ads-software.com/Restoring_Your_Database_From_Backup
and I got the following error there: #1044 – Access denied for user ‘[username]’@’localhost’ to database ‘wordpress’

Any thoughts on those? Thanks again!

Delete the plugins/cform2 plugin and reupload/reinstall the Cform2 plugin.

Beautiful! Took care of the Warning messages (updated cforms too) and I can log out now.

Still having the SQL error though. Should I make a new post, since it’s not really on topic? Thanks!

#1044 – Access denied for user ‘[username]’@’localhost’

Make sure your database user has full privileges to the database–if not sure ask host.

ARGH. Asking my host will be like pulling teeth. Here’s my info as shown on the
MySQL Account Maintenance page —

Current Databases:
tekni2_wordpress

Users in wordpress
tekni2_tekadmin (Privileges: ALL PRIVILEGES)

Connection Strings
Perl $dbh = DBI->connect(“DBI:mysql:tekni2_wordpress:localhost”,
“tekni2_tekadmin”,”<PASSWORD HERE>”);
PHP $dbh=mysql_connect (“localhost”, “tekni2_tekadmin”,
“<PASSWORD HERE>”) or die(‘Cannot connect to the database because: ‘ . mysql_error());
mysql_select_db (“tekni2_wordpress”);

tekni2_wrdp1 (Privileges: ALL PRIVILEGES)

And here’s my wp-config —

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'tekni2_wordpress');

/** MySQL database username */
define('DB_USER', 'tekni2_tekadmin');

/** MySQL database password */
define('DB_PASSWORD', '<password>');

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

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

Doesn’t that look right? Same error.

ARGH. Asking my host will be like pulling teeth. Here’s my info as shown on the
MySQL Account Maintenance page —

Current Databases:
tekni2_wordpress

Users in wordpress
tekni2_tekadmin (Privileges: ALL PRIVILEGES)

Connection Strings
Perl $dbh = DBI->connect(“DBI:mysql:tekni2_wordpress:localhost”,
“tekni2_tekadmin”,”<PASSWORD HERE>”);
PHP $dbh=mysql_connect (“localhost”, “tekni2_tekadmin”,
“<PASSWORD HERE>”) or die(‘Cannot connect to the database because: ‘ . mysql_error());
mysql_select_db (“tekni2_wordpress”);

tekni2_wrdp1 (Privileges: ALL PRIVILEGES)

And here’s my wp-config —

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'tekni2_wordpress');

/** MySQL database username */
define('DB_USER', 'tekni2_tekadmin');

/** MySQL database password */
define('DB_PASSWORD', '<password>');

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

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

Doesn’t that look right? Same error.

I don’t know if this is related, but if I go into phpMyAdmin and go to Information Schema to check USER_PRIVILEGES, I get this result:
GRANTEE TABLE_CATALOG PRIVILEGE_TYPE IS_GRANTABLE
‘tekni2’@’localhost’ NULL USAGE NO

And this error at the bottom of the page: “unknown table status: TABLE_TYPE”

Try changing your $table_prefix in wp-config.php and WordPress will install another set of tables and see if that works.

Hi again Michael —

Got lucky with host support! They suggested that if the MySQL file was trying to create a DB that I get rid of that line. So I commented out

/*CREATE DATABASE IF NOT EXISTS wordpress;
USE wordpress;*/

And it imported with no problem. NOW (of course; it’s one thing after another with me), when I went to the index page, I was told that I was starting the famous 5-minute install. So I went ahead with that and now I have a fresh, clean WP site…

I’m not panicking; I know I have all of the pieces, but I just can’t seem to get them together in the right order.

Of course, I will start panicking when client starts yelling at me that they want the site up and running yesterday…

Thanks again for all the help (and sorry for the inadvertent double-post yesterday).

ARGH again. Everything uploaded, permissions set, now when trying to log in at wp-admin, I get a 500 Internal Server Error.

Just minutes ago I WAS able to log in and had the default template. Then I changed permissions and blooey.