Posted on December 31st, 2007 by Jannu
As the database is a critical thing to handle, one needs to monitor and take backups periodically. For this following command is used to take backup of MySQL Database.
#mysqldump -u user_name -p pass_word db_name > db_name.sql
For restoring the database from the backup file:
#mysql -u root -p root_password db_name < db_name.sql
Powered by ScribeFire.
Popularity: 51% [?]Share This
Popularity: 51% [?]
1 Comment »
Filed under: Mysql Tips & Tricks
Posted on December 31st, 2007 by Jannu
If you are not giving the below said privileges to the user, then you
can only give permissions to appropriate database as shown below:
mysql> grant all privileges on guest.* to
-> ‘guest’@'localhost’ identified
-> by ‘1234567890′ with grant option;
mysql> flush privileges;
Here ‘guest’ is the Database name and ‘guest.*’ means granting […]
Popularity: 42% [?]
1 Comment »
Filed under: Mysql Tips & Tricks
Posted on December 31st, 2007 by Jannu
For adding a new user to MySQL you just need to add a new entry to user table in database mysql. Login as root to mysql as shown below:
$ mysql -u root -p (if Root Password is set.)
$ mysql -u root (If password is not set for root)
It is recommended to have […]
Popularity: 40% [?]
No Comments »
Filed under: Mysql Tips & Tricks
Posted on December 31st, 2007 by Jannu
Method 1#If you have never set a root password for MySQL, the server does notrequire a password at all for connecting as root. To setup rootpassword for first time, use mysqladmin command at shell prompt asfollows:
$ mysqladmin -u root password NEWPASSWORD
However if you want to change (or update) a root password, then […]
Popularity: 43% [?]
No Comments »
Filed under: Mysql Tips & Tricks, Uncategorized
Posted on December 28th, 2007 by scooby
What are Handlers?
Handlers are interceptors, which can be easily plugged into the JAX-WS runtime system to process the SOAP inbound and outbound messages.
JAX-WS defines two types of handlers: Protocol handlers and logical handlers.
Protocol handlers are specific to protocol such as SOAP. They can modify any […]
Popularity: 28% [?]
No Comments »
Filed under: Web Services
