PhpMyAdmin, a free web-based MySQL admin tool, quite commonly used specially with Web-Servers, can be a great tool. MySQL Export and Import Data with phpMyAdmin When to use the Command-line for Export/Import …įor the export of data, we will use the “mysqldump” command, which you’ll have to locate first. The advantage of a dump like this, from SSH/Command-line, are speed (everything remains local), full control and capable of handling pretty much any amount of data. The more seasoned MySQL Database Admin will probably prefer using the command-line, but there are other options that might be easier unless a more advanced level of control is needed. MySQL Export and Import Data from the Command-line Obviously I didn’t benchmark it perfectly, so consider this just an indicator. Interesting to see that Command-line and MySQL Workbench are very close when it comes to speed. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |