SQLite to MySQL

easycompany
Posts: 6
Joined: Sun Jan 02, 2011 9:30 am

SQLite to MySQL

Postby easycompany » Sat Jan 08, 2011 12:16 pm

Hello,

Can anybody help and tell me if the MySQL migration was successful?

Code: Select all

[root@EasyServer EasyCompany]# uname -r; rpm -q samba hda-greyhole 2.6.35.10-74.fc14.x86_64 samba-3.5.6-71.fc14.x86_64 hda-greyhole-0.8.3-2.x86_64

Code: Select all

[root@EasyServer EasyCompany]# /usr/share/greyhole/db_migration-sqlite2mysql.sh Stopping Greyhole service watchdog... Reloading monit: Reinitializing monit daemon Done. Stopping Greyhole service... Shutting down Greyhole: [ OK ] Done. Creating MySQL database and user... hda-create-db-and-user: creating greyhole ERROR 1396 (HY000) at line 2: Operation CREATE USER failed for 'greyhole'@'localhost' ERROR 1050 (42S01) at line 1: Table 'settings' already exists Done. Modifying Greyhole configuration to use MySQL... Done. Migrating data from SQLite to MySQL... Error: unknown command or invalid arguments: "dump". Enter ".help" for help Done. Starting Greyhole service... Starting Greyhole ... [ OK ] Done. Starting Greyhole service watchdog... Reloading monit: Reinitializing monit daemon Done. [root@EasyServer EasyCompany]# PHP Warning: date_default_timezone_get(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST' instead in /usr/bin/greyhole on line 39

User avatar
gboudreau
Posts: 606
Joined: Sat Jan 23, 2010 1:15 pm
Location: Montréal, Canada
Contact:

Re: SQLite to MySQL

Postby gboudreau » Tue Jan 18, 2011 7:13 pm

FC14 now uses MySQL by default, thus why you're getting error messages by running the migration script.
- Guillaume Boudreau

Who is online

Users browsing this forum: No registered users and 30 guests