using the video tutorial db offline?
Posted: Tue Mar 09, 2010 6:37 am
I'd like to be able to use the database for the video training http://demo.nubuilder.com/db/nuvideo/ offline.
To that end I have logged in to the site and used the "Backup" button to generate the "db_nuvideo.sql" file. Then I used phpMyAdmin's "Import" function to restore the database on a WindowsXP install of nuBuilder 9.9.23 including Apache, MySQL, and php.
After adding a USE statement to the .SQL file it will attempt to restore the db, but it fails with an error; seems it dosn't like CHAR(x) where x>255. I've tried fixing this two ways: change CHAR(x) to BLOB(x), and forcing x>255 to be x<255. both methods produce further errors.
Can anyone suggest how to properly do this?
To that end I have logged in to the site and used the "Backup" button to generate the "db_nuvideo.sql" file. Then I used phpMyAdmin's "Import" function to restore the database on a WindowsXP install of nuBuilder 9.9.23 including Apache, MySQL, and php.
After adding a USE statement to the .SQL file it will attempt to restore the db, but it fails with an error; seems it dosn't like CHAR(x) where x>255. I've tried fixing this two ways: change CHAR(x) to BLOB(x), and forcing x>255 to be x<255. both methods produce further errors.
Can anyone suggest how to properly do this?