mysql database

Where Are MySQL Files Stored in UNIX / Linux

by Vivek Gite on February 25, 2009 · 0 comments

Where are my mysql database and table files are stored in UNIX or Linux operating systems?

{ 0 comments }

How do I specify MySQL SQL queries on the UNIX / Linux command line?

{ 10 comments }

MySQL List Databases

by Vivek Gite on April 12, 2008 · 3 comments

Q. How do I display a list of all databases under MySQL Server?

{ 3 comments }

How do I start and stop mysql server under Debian / Ubuntu Linux system?

{ 0 comments }

Q. I’m moving my server from local data center to another data center. I’ve new server up and running. My site is dynmic and I’d like to transfer MySQL database from old server to new server. How do I make transfer smooth and successful? A. The best and secure way is to use ssh to [...]

{ 2 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?

{ 53 comments }

MySQL Change root Password

by Vivek Gite on January 2, 2006 · 106 comments

How do I change MySQL root password under Linux, FreeBSD, OpenBSD and UNIX like operating system over ssh / telnet session?

{ 106 comments }