Zmiana hasła root i backup
mysql> grant all on *.* to root@"129.79.78.%" identified by "{root mysqluser password}" with grant option;
Query OK, 0 rows affected (0.00 sec)
user@linux:~/files/blog>
mysqldump --add-drop-table -h mysqlhostserver -u mysqlusername -p databasename (tablename tablename tablename) | bzip2
-c > blog.bak.sql.bz2 Enter password: (enter your mysql password)
user@linux~/files/blog>
This entry was posted
on czwartek, maj 17th, 2007 at 8:41 po południu and is filed under Linux, MySQL.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.