Rolling Resource

mysql> show grants for ‘olduser’@'localhost’; +—————————————————————————————————————-+ | Grants for newuser@localhost | +—————————————————————————————————————-+ | GRANT USAGE ON *.* TO ‘olduser’@'localhost’ IDENTIFIED BY PASSWORD ‘*D8DECEC305209EEFEC43008E1D420E1AA06B19E0′ | | GRANT USAGE ON `database`.* TO ‘olduser’@'localhost’ WITH GRANT OPTION | +—————————————————————————————————————-+ 2 rows in set (0.00 sec)

mysql> REVOKE ALL PRIVILEGES ON `database` . * FROM ‘olduser’@'localhost’; Query OK, 0 rows affected (0.00 sec)

mysql> REVOKE GRANT OPTION ON `database` . * FROM ‘olduser’@ ‘localhost’; Query OK, 0 rows affected (0.00 sec)

mysql> REVOKE ALL PRIVILEGES ON * . * FROM ‘olduser’@ ‘localhost’;

mysql> DROP USER ‘olduser’@ ‘localhost’;

mysqldump --opt -Q -uUSERNAME -p DATABASENAME > /PATH/TO/DUMP.SQL

n this line, you should change the following: USERNAME – this is the username you use to access MySQL. It is specified in your config.php file. DATABASENAME – the name of the database which your vBulletin is installed into. It is specified in your config.php file. /PATH/TO/DUMP.SQL – this is the path to the file that will be outputted. If you are unsure what to put here, simply use dbname_bak.sql or something similar.

When you press enter, you will be prompted for the password you use to access MySQL. This is also specified in your config.php file. The system will dump the database once you have entered the correct password. Verify that DUMP.SQL exists in the directory you specified. If you did not specify a full directory, the file will be in the directory you are currently in.

Repeat this procedure for each database you wish to backup.

Use the following command to create a symbolic link in Unix

ln -s ActualFilename LinkFileName

Example: ln -s /var/www/html/ webpages will create a link called webpages to /var/www/html in the current directory.