Testing Latest Version (error)

[mweaver]

(03-04-2017, 10:04 PM)joebordes Wrote: you have to create a backup of your production database using mysqldump:

mysqldump -u {user} -p {your_db_name} > dbbackup_Ymd.sql

this will create a total dump of your database into the file dbbackup_Ymd.sql

now you can take this file to any other server in the world and recover it there. Basically, create a new database there, with UTF8 charset and then load the dump into it with:

mysql -u {user} -p {new_db_name} < dbbackup_Ymd.sql

So, when I say "copy the database", I mean make a dump of the database and recover it into a new database using the procedure above

keep asking....

Thank you for the clarification... I'm getting an error when I import the dump and I'm not sure we'll get past this one unless you've got some magic in a hat somewhere.

Code:

]$ mysql -u mweaver corebos7 -p < vtcrmdump.sql

Enter password:
ERROR 1215 (HY000) at line 3166: Cannot add foreign key constraint

  When I log in, except for the home page, other pages are blank. Essentially anything that depends on the database for content to populate the page is blank, so unless you've got a little more magic in your hat I'm not sure we're going to get past this one. That poor old fart of a database has seen a few things over the years. Originally it was a vTiger database that got migrated through a few versions. Then, it was converted to CoreBOS a few years ago. I might just be asking too much of it. Unless there's a way to convert that I'm not aware of.