I already have a MySQL database. How do I get it up and running on your server for my Lasso 5 or 6 account?
In the following examples, we will assume you're using Lasso 6. If you're using Lasso 5, simply change any reference to "LassoProfessional6" to "LassoProfessional5".
In all cases, you'll first want to log into the digital.forest Lasso Manager (see above) and create a blank database with the same name as the database you'd like to import &151; create the database, but be sure not to create any tables. This makes it easy for Lasso and mySQL to "recognize" your database once it's imported.
If at all possible, create a "dump" file of your existing mySQL database &151; generally the easiest way is to connect to your existing mySQL server with an external client program and use the client's command to create a dump. You can also use the mysqldump command to generate a dump, which is located in the:
/Applications/LassoProfessional6/LassoMySQL/bin
...directory. Under Mac OS X, try the following command from the terminal:
/Applications/LassoProfessional6/LassoMySQL/bin/mysqldump (your database name) > /test.dump
If you run into a permissions error, try:
/Applications/LassoProfessional6/LassoMySQL/bin/mysqldump -u root -p (your database name) > /test.dump
Either command will create a "test.dump" file at the root level of your hard drive that will contain all the data we need. You can then use an external client to upload that "test.dump" to our server.
If you only have access to a raw copy of the tables from the database, upload them into a folder within your site (eg, Databases) and e-mail support@forest.net with the location of the files and the name of the database they belong to. We will do our best to install them into mySQL and contact you as soon as possible.
Either way, be sure to then set up security at both the database and table level after your tables have been imported.