Adminer – manage MySQL by single file, alternative of phpMyAdmin

Adminer impressed me when I first tested it. It is superb alternative to the most famous MySQL web based administration tool phpMyAdmin. I just counted number of files in my current phpMyAdmin installation and I found there are 642 items. But Adminer is only a single file. You need to download it from there website [...]

MySQL database import-export from Shell

The control panels provide GUI for import / export databases. However, it is very easy doing the same from shell. Exporting Database mysqldump dbname > exportfile.sql This will export the database to exportfile.sql. You can optionally compress the file to save bandwidth during server to server transfer. Run the following command: gzip exportfile.sql Database Import [...]