Mysql Post: 83146

Sponsored Content

Top Forums UNIX for Advanced & Expert Users Mysql Post 83146 by indo1144 on Monday 12th of September 2005 03:10:33 AM

09-12-2005

Registered User

I am not a MySQL guru, I sometimes need to do administrative jobs though and have run into the same problem from time to time.

From the RH-machine, can you connect to your database using "mysql -u root -p" ?

Depending on your permissions, you sometimes must sometimes use this notation:

mysql -u root -p
mysql -h localhost -u root -p (connect using localhost)
mysql -h 192.168.0.1 -u root -p (connect using IP)
mysql -h mymachine -u root -p (connect using hostname)

If any of these fail, you may have other problems, check mysql-permissions.

To dump the entire database-server (including all databases, tables, including create-statements) I sometimes use this:

Code:

/usr/bin/mysqldump --all-databases --opt --user=root --password=xxxxxx > /root/scripts/mysql_backup/dump.sql
(run from database server itself, so I do not use -h option)

Last edited by indo1144; 09-12-2005 at 06:37 AM..

indo1144

View Public Profile for indo1144

Find all posts by indo1144

6 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL...

2. UNIX for Advanced & Expert Users

mysql would not start: missing mysql.sock

I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql: #...

3. Red Hat

MySQL conflicts with mysql-3.23.58-16.RHEL3.1

I am tring to install mysql 5.0 on redhat linux3. In this server mysql 3 is already installed and hence while I install mysql 5 it gives the following error. How I can install mysql 5 with out affect previous installation? bash-2.05b# rpm -i MySQL-server-community-5.0.41-0.rhel3.i386.rpm...

4. Linux

mysql

Hi all, How I can find out how long is mysql server is down and is it writing data or not? thanks,

5. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)...

6. Programming

Mysql++

code: #include <mysql/mysql.h> #include <my_global.h> int main(int argc, char **argv) { MYSQL *conn; conn = mysql_init(NULL); mysql_real_connect(conn, "localhost", "zetcode", "passwd", "testdb", 0, NULL, 0); mysql_query(conn, "use vobd_db"); mysql_query(conn, "select *...

LEARN ABOUT DEBIAN

grass-mesql

grass-mesql(1grass)						Grass User's Manual					       grass-mesql(1grass)

NAME

       grass-mesql - MySQL embedded driver

       MySQL  embedded	driver	MySQL  embedded  driver  in GRASS MySQL database driver in GRASS enables GRASS to store vector attributes in MySQL
       embedded database without necessity to run MySQL server.

Driver and database name
       GRASS modules require 2 parameters to connect to a database.  Those parameters are 'driver' and 'database'. For MySQL embedded  driver  the
       parameter  'driver'  should  be	set  to value 'mesql'.	The parameter 'database' is a full path to the directory where database tables are
       stored. The best place is a directory in the mapset. The directory must be created before use of the driver. In the name of database it	is
       possible to use 3 variables:

		      $GISDBASE - path to current GISBASE

		      $LOCATION_NAME - name of current location

		      $MAPSET - name of current mapset

       Examples of connection parameters:
	 db.connect driver=mesql database='$GISDBASE/$LOCATION_NAME/$MAPSET/mysql'
	 db.connect driver=mesql database=/home/user1/db

Data types, indexes
       For more informations about supported data types and indexes see the documentation for MySQL (mysql) driver

Database type
       Because	database  closing  was	found  very  slow if InnoDB was used, the InnoDB storage is disabled by default (hardcoded '--skip-innodb'
       server option).

Note
       The embedded server is started with hardcoded '--bootstrap' option to avoid warning about missing mysql.time_zone_leap_second  table.  This
       can be fixed in future.

SEE ALSO

	db.connect, SQL support in GRASS GIS

Credits
       Development of the driver was sponsored by Faunalia (Italy) as part of a project for ATAC.

AUTHOR

       Radim Blazek

       Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
       Help Index

GRASS 6.4.2														       grass-mesql(1grass)