mysql command

MySQL command to show list of databases on server

by on November 28, 2006 · 37 comments

Q. I am new to MySQL database server. How do I show the list of databases on my server? Is there any good GUI frontend exists for the same?

{ 37 comments }

Import MySQL Dumpfile, SQL Datafile Into My Database

by on August 23, 2006 · 61 comments

How can I import a MySQL dumpfile into my database? I’m using CentOS Linux 5 server. My old hosting provider gave me a data.sql file and I do have access to my Unix / Linux server via ssh. So How do I restore my data using command line over the ssh session?

{ 61 comments }

How can I restore a backup of a MySQL database?

by on July 29, 2006 · 1 comment

Q. I made MySQL backup using mysqldump -u user -h localhost -ppassword forumdb | -gzip -9 > forumdb.sql.gz command. How do I restore MySQL database backup using a shell prompt under Linux / UNIX operating system?

{ 1 comment }

Access MySQL Server From The Shell Prompt (Command Line)

by on March 28, 2006 · 7 comments

How do I access MySQL server from the shell prompt (command line)?

{ 7 comments }

Mysql user creation – setting up a MySQL new user account

by on January 1, 2006 · 14 comments

When you try to access MySQL database server from client such as mysql or even programming language such as php or perl you need a user account. MySQL has sophisticated user management system that controls who can access server and from which client system. It uses special tables in mysql database. In order to create [...]

{ 14 comments }

Next HowTos →