MYSql Database import?

[ricoj1321]

Howdy everyone. These forums have been great that I have never needed to post to it.
Heres the dilly-o:
Host went down, unable to connect to network despite all troubleshooting, problem with machine obviously unable to resolve at all.

Ok so we were running 1.2.12 and now that 2.1.4 is out I have that up and running on another machine.

I have successfully dumped the DB and schema from the old mysql server AND successfully imported it into the new systems mysql system.

Upon relaunch of services, the new site does not recognize any of the database items, though I have verified the tables contents.

Has anyone any experience in performing this operation, and if so, were there any peculiarities that you encountered?

Thanks!

[wingoo]

The structure is different for the db in 2. You would have to create a new database for 2 with a different name as per the install then run the migrate in the install instructions to copy the data over.

[ricoj1321]

Thanks for the FYI. I tried that particular method, and enabled the php4log but nothing ended up in my log folder

What I do get is when I hit Run Migration:

Unknown Error.

Thoughts?

[wingoo]

I had this when I migrated, but it was an earlier version.

The solution then was here

http://php.brickhost.com/forums/index.php?topic=11013.msg19314#msg19314


Don't know if it will help

[ricoj1321]

I had this when I migrated, but it was an earlier version.

The solution then was here

http://php.brickhost.com/forums/index.php?topic=11013.msg19314#msg19314


Don't know if it will help

I will give it a shot and find out..heres a copy from another post of mine that might give more info:

I just installed 2.1.4 on a new host dumped the sql db from old host which has hardware failure on mobo. I have 2.1.4 running just fine on new host, dumped sql_bak into new old_db in mysql on new host. Created new phpscheduleit2 db according to instructions and all is running well.

What happens is when I go to migrate.php and try to run it against the old_db (recreation of sql_bak, all tables show just fine) I get an unknown error and nothing migrates. I have been unable to determine the issue (one sticky issue was the hostpec being 127 versus lcoalhost in config.php, for me it has to be localhost to work) Thanks!

[ricoj1321]

I had this when I migrated, but it was an earlier version.

The solution then was here

http://php.brickhost.com/forums/index.php?topic=11013.msg19314#msg19314


Don't know if it will help

Actually now that I went through migrate.php it looks like those changes were integrated into version 2.1.4 but for me they are not working. I might try reverting it to the old version and see if it works.

[Nick]

Actually now that I went through migrate.php it looks like those changes were integrated into version 2.1.4 but for me they are not working. I might try reverting it to the old version and see if it works.

What part is not working?

[ricoj1321]

Hi Nick
I have since revisited this topic, having given up back in May. Since then, our 1.2.12 server crashed and now I am forced to migrate.
I have successfully gotten 2.3.3 up and running (with the exception of the script.url redirect not working despite following the directions)

That aside:
I am trying to run /Web/install/migrate.php

I either get Unknown error, or I get Cannot connect to 1.2 database

Here are the errors in error_log

I tried to add require_once(ROOT_DIR . 'lib/Database/MySQL/namespace.php'); to migrate.php as suggested in another thread, without any success.
I know that the username and passwords are correct. I know that the user account in mysql has all grants on the old db, but no matter what migrate.php says it either cannot connect, or it has an unknown error.

[Fri Oct 19 21:33:30 2012] [error] [client 128.164.102.98] PHP Warning:  mysql_connect(): Access denied for user 'XXXXXX@'localhost' (using password: YES) in /var/www/html/phpScheduleIt/lib/Database/MySQL/MySqlConnection.php on line 53, referer: http://XXXXXXXXX/Web/install/migrate.php [Fri Oct 19 21:33:30 2012] [error] [client 128.164.102.98] PHP Warning:  mysql_select_db() expects parameter 2 to be resource, boolean given in /var/www/html/phpScheduleIt/lib/Database/MySQL/MySqlConnection.php on line 54, referer: http://XXXXXXX/Web/install/migrate.php

[ricoj1321]

I should also mention that the mysql db is on the same host as the new system. the old system went kaput. I dumped the mysql db with mysqldump and then did a mysql -u -p old_db < dumpdb.sql and that is the db that i am trying to migrate into the phpscheduleit2 db.

[Nick]

It sounds like configuration or credentials to the old database aren't set correctly.