• I have WordPress running OK on one virtual domain.

    I created a new virtual domain and installed WordPress on it successfully too, but when I attempted to import a backed up database, the new blog stopped working. (I was attempting to migrate the first blog to the second domain. I believe there is a way to change the settings on the first blog to work under the second domain but I would really like to have both going simultaneously at least for a while so I attempted the export/import.)

    When the import failed, and nothing seemed to work, I uninstalled WordPress on the new domain and I’m trying to reinstall.

    When I do, vinstall gives me this error:
    sqlapp(stat: 1): use wpdb_procommvoices_com; show tables;
    MySQL can’t auth user.
    I have used vinstall with –sqlpw entered but still no go.

    (I have access to my db at /var/lib/mysql/(domain_name) and have backed up all the files inside the domain folder.) I also have several backups of the existing blog. One is the xml file created by the WordPress:Tools:Export. Another b/u is the PHPMyAdmin sql (rather large) and gz files. Still another is the WordPress Database Backup output.

    I think my only alternative at this point (with my limited knowledge) is to reinstall mysql and opt for delete all databases (which will kill the existing blog).

    Is there another way out of this problem?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The db username will have to have global privileges to access a database on a different virtual domain.

    Thread Starter procommss

    (@procommss)

    Yep, I have the user name and password for both databases. The fact that I got WordPress installed on the second domain indicates this.

    I guess what I’m asking here is… If I have my /var/lib/mysql/ folder with the two domain folders and the subordinate mysql folder copied and my wordpress-2.7 folder backed up, with a very standard installation, am I covered?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Mysql database problem’ is closed to new replies.