WordPress.org

1. amateur6
   Member
   Posted 2 years ago #

   Following the instructions at http://codex.wordpress.org/Moving_WordPress#Moving_WordPress_to_a_New_Server_with_Fantastico

   Step 2 says "Upload your plugins and themes from your old site to the new one."

   I'm at a design shop; we hired a WP developer to do a custom site and now I need to install it on the client's site. I have the .sql backup; but I'm not sure how to get the plugins and custom theme (it's based on minimalism; is that all I need?)...

   Total newbie question, I know -- I've done clean installs of WP before, and I know my way around css, but this feels a little over my head.

   I also already exported and imported the .xml file. I probably shouldn't have done that, right?

   Help much appreciated -- client isn't quite ready to go live, but will be VERY SOON!

2. MichaelH
   Volunteer
   Posted 2 years ago #

   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.

3. amateur6
   Member
   Posted 2 years ago #

   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!

4. MichaelH
   Volunteer
   Posted 2 years ago #

   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.

5. amateur6
   Member
   Posted 2 years ago #

   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!

6. MichaelH
   Volunteer
   Posted 2 years ago #

   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.

7. amateur6
   Member
   Posted 2 years ago #

   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 http://codex.wordpress.org/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!

8. MichaelH
   Volunteer
   Posted 2 years ago #

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

9. amateur6
   Member
   Posted 2 years ago #

   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!

10. MichaelH
    Volunteer
    Posted 2 years ago #

    #1044 - Access denied for user '[username]'@'localhost'

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

11. amateur6
    Member
    Posted 2 years ago #

    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.

12. amateur6
    Member
    Posted 2 years ago #

    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.

13. amateur6
    Member
    Posted 2 years ago #

    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"

14. MichaelH
    Volunteer
    Posted 2 years ago #

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

15. amateur6
    Member
    Posted 2 years ago #

    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).

16. amateur6
    Member
    Posted 2 years ago #

    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.

17. amateur6
    Member
    Posted 2 years ago #

    Never mind that "blooey" -- got it back. Accidentally set wp-content/admin to 777.

    Also re-upping everything; looks like I accidentally re-upped the "blank" install. Dag-nabbit.

18. amateur6
    Member
    Posted 2 years ago #

    Okay. Some other issues still cropped up, but none related to install.

    Went back, removed WP using Fantastico, re-installed using Fantastico, followed all instructions above, all is well.

    Exception: pages didn't want to keep their plug-in assigned status, but again -- not an install or move issue.

    Thanks for all of your help and patience, Michael.

Topic Closed

This topic has been closed to new replies.