Archive for the 'MySQL' Category
Viewing 21-30 of 35 FAQ -- MySQL server status with mysqlreport report script :
Q. How to find out more information about MySQL server status?
A. The MySQL server maintains many status variables that provide information about its operation. You can see upto date variables lists and explanation of its usages online. For example you can connect to MySQL server and execute SHOW STATUS
$ mysql -u vivek -p
mysql> show status;
Output:+——————————–+————+
| [...] - What is my root password for MySQL? :
Q. I have just installed mysql. I don’t know how to connect as well as what is my root or mysql admin password for MySQL?
A. Your default mysql password is empty (i.e. no password). For example:Username: root
Password: emptyHowever if you use something like Plesk software use following information:
User: admin
Password: adminAbove is just a default password. [...]
- How to access MySQL database using Perl :
Q. How do I access my MySQL database server using Perl programming language?
A. DBI is a generic interface for many databases. That means that you can write a script that works with many different database engines without change. You need a DataBase Driver (DBD) defined for each database type. For MySQL, this driver is called [...] - How to: Connect to my MySQL Database server using command line and php :
Q. How do I connect to my MySQL database server using command line (over ssh) or using PHP?
A. You can connect to MySQL database server using mysql command line client or using programming language such as PHP or perl.
Task: Use command line client - mysql
Genral syntax is as follows:
mysql -u DBUSER -h DBSERVERNAME -p
So [...] - Import MySQL dumpfile, SQL datafile into my database :
Q. How can I import a MySQL dumpfile into my database? My old hosting provider gave me data.sql file. I do have access via ssh to server. I’m using CentOS Linux 5 server.
A. You can easily restore or import MySQL data with mysql command itself. First you need to login to your system using ssh [...] - How can I restore a backup of a MySQL database? :
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?
- MySQL error 28 and solution :
Q. I am getting an error that read as follows:
MySQL: got error 28 from server handler
How do I fix this problem?
A. This error means no space left on hard disk. According to official MySQL docs, “If you get his error, you need to check all filesystems where MySQL operates. It may be single filesystem [...] - PHP not connecting to a MySQL database server :
Q. I have Apache Web server and MySQL configured. Everything works fine except I am not able to connect to a MySQL database server (I am able to connect mysql server with mysql client). So how do I configure or connect PHP scripts?
A. You need to install MySQL module for php4 or php5. Without php-mysql [...] - GUI Tools for managing MySQL databases server :
Q. I am new to both Linux and MySQL database server. Can you provide any name og GUI tools for managing MySQL databases server remotely as well as locally?
A. MySQL has various GUI tools for managing MySQL databases server remotely as well as locally. However not all software are free. Here are two best free [...] - Howto: Use tar command through network over ssh session :
Q. How do I use tar command over secure ssh session?
A. The GNU version of the tar archiving utility (and other old version of tar) can be use through network over ssh session. Do not use telnet command, it is insecure. You can use Unix/Linux pipes to create actives. Following command backups /wwwdata directory [...]
« Previous Page — Next Page »
Viewing 21-30 of 35 FAQ -
Recent Comments
Today ~ 1 Comment
Today ~ 2 Comments
Yesterday ~ 9 Comments
Yesterday ~ 32 Comments
07/04/2008 07:04 pm (2 days ago) ~ 1 Comment