Top menu

Useful Linux Commands

To decompress a file with .tar.gz extension use the command line below :

Phpmyadmin, it is pretty, it is practical but compared to the use of mysql command line via ssh for example on your dedicated server, it has nothing to do when you start a process large databases sql several mega.

Indeed to a mysql export, if one goes through php we already have the max-execution time which may cause us problems.
Something that does not happen with tools like mysqldump.

To make a backup of the database mysql, here is the syntax:

Do not forget to paste the password to the ‘p’.

Finally to import a mysql database on the command line is almost identical:

Little tip, if you want to import a mysql specifying the encoding, use the –default_character_set utf8 option

Check installed PHP extensions

Checking your Ubuntu Version

 

No comments yet.

Leave a Reply