mysql files

[niziptv]

I want to get my mysql files via FTP. However, I cannot go up to that level. How can I access the raw mysql files via FTP? I am registered user of siteground.

[kenny]

You cannot access the raw files of your MySQL databases -- those are placed in a special directory that only the mysql user has read and write privileges for.

To take a backup of your dababases, you can use the phpMyAdmin tool in cPanel -- an SQL dump of a database is the most convenient way to export a database -- it can easily be restored on another MySQL (or other sort of SQL) server, * disabled word ** disabled word ** disabled word ** disabled word ** disabled word ** disabled word ** disabled word *ting structure and data completely.

[mudanoman]

Are there any special checks that need to be made under structure or data? Screen shot attached. Thanks.

[mudanoman]

bump...any help.

[matthewm]

Your screenshot looks fine, just click Go.

[kenny]

The screenshot looks ok, and the exported dump will probably work.

I have 2 recommendations:

1. Check the "Add Drop Table" box -- thus, if you need to import over an existing structure, the current data will be dropped, and replaced by the data in the SQL dump. Without this checked, you will get errors, and will have to drop the tables manually, before you can import.

2. You may wan to select "MySQL 4.0" from the "SQL Compatibility" dropdown menu -- this avoids a bug in MySQL that will corrupt any non-latin1 characters, and the dump will import properly even on MySQL 4.0 (of course, the same dump will work on 4.1 too )