Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
examples [2013/07/18 04:13] gcamara |
examples [2013/07/18 11:47] (current) pedro |
||
---|---|---|---|
Line 14: | Line 14: | ||
If you are a Mac OS X user and would like to convert an Access database (.mdb) to a mySQL database to use in TerraME on a Mac, please follow the following steps: | If you are a Mac OS X user and would like to convert an Access database (.mdb) to a mySQL database to use in TerraME on a Mac, please follow the following steps: | ||
- | 1. Use the application "MDB ACCDB Viewer" to open your MDB file on a Mac. The app is not open source, but it's cheap and worth the money, since there are no good FOSS to do the conversion. | + | - Use the application "MDB ACCDB Viewer" to open your MDB file on a Mac. The app is not open source, but it's cheap and worth the money, since there are no good FOSS to do the conversion. |
- | + | - Export the MDB file to SQL using the "MDB ACCDB Viewer". | |
- | 2. Export the MDB file to SQL using the "MDB ACCDB Viewer". | + | - Use the very good FOSS "Sequel Pro" to import your SQL file to your mySQL database. |
- | + | - If the import operation is successful, you should have a list of TerraLib compatible tables shown in the "Sequel Pro" app. Go to the "te_view" table, and show its contents. You will see that the "user name" field is blank. Please enter your SQL username here. | |
- | 3. Use the very good FOSS "Sequel Pro" to import your SQL file to your mySQL database. | + | |
- | + | ||
- | 4. If the import operation is successful, you should have a list of TerraLib compatible tables shown in the "Sequel Pro" app. Go to the "te_view" table, and show its contents. You will see that the "user name" field is blank. Please enter your SQL username here. | + | |
That's it! If you don't succeed, send an email to Gilberto Camara <gilberto.camara@inpe.br>. | That's it! If you don't succeed, send an email to Gilberto Camara <gilberto.camara@inpe.br>. |