Category Archives: MySQL

Problems and solutions I’ve found using this great system database manager.

How to made a copy of a MySql database using the console.

Some times I happened that, I need get a copy of a data base running on MySql but the server can’t access using some graphical tools how MySql Workbench or HeidiSQL. If you also happened, don’t turn crazy, if you have access to the server using the linux console, exist an alternative. You can generate a copy of your data base using the program mysqldump that is common that this installed in the most servers that have installed the MySql service (for make maintenance of him).

For extract the data base info and save in a file, you must execute the next command:
Continue reading