Re: MySQL My program
Philip Mather wrote: Mohsen, First off, what version of MySQL are you running and on what platform? Now when i use --skip-grant-tables i can see my databases. Please help me... When you use MySQL via a shell I would assume you're logging in as root? You also say you can only see a test database, can you not see a mysql database there as well? I would suggest that somehow either the mysql database has been dropped/destroyed or perhaps just the db, host, tables_priv, and user tables of that database have been dropped/destroyed/messed up. Log in via shell and show us the result of the following commands... mysql use mysql; mysql show tables; mysql SELECT COUNT(*) FROM db; mysql SELECT COUNT(*) FROM user; If you can't see the database and/or the tables I'm talking about you may want to just check your backups are working and come back to us. Regards, Phil When i use ps ax |grep mysql i see following statements: 6173 ?S 0:00 /bin/sh /home/arman/mysql/bin/mysqld_safe --basedir=/home/arman/mysql/ --datadir=/home/arman/mysql/var/ --socket=/tmp/arman.sock --port=3310 --user=root --skip-grant-tables 6220 ?S 1:21 /home/arman/mysql/libexec/mysqld --basedir=/home/arman/mysql/ --datadir=/home/arman/mysql/var/ --user=root --pid-file=/home/arman/mysql/var//lnxsrv2.pid --skip-locking --port=3310 --socket=/tmp/arman.sock --skip-grant-tables Now when i use following command : [EMAIL PROTECTED] root]# /home/arman/mysql/bin/mysql --port=3310 --socket=/tmp/arman.sock --user=root -p then input password i see following message: Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) So,I can't use use command in mysql shell. Yours,mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL My program
Dear all, I have a JSP program whish is using MySQL database engine. It was working successfully,Now it doesn't work. Note: When i use mysqlshow command , i see test bank only.But if i use mysql shell use show databases,I can see all my databases. It's emergency. Please help me -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL My program
Mohsen Pahlevanzadeh wrote: Dear all, I have a JSP program whish is using MySQL database engine. It was working successfully,Now it doesn't work. Note: When i use mysqlshow command , i see test bank only.But if i use mysql shell use show databases,I can see all my databases. It's emergency. Please help me Now when i use --skip-grant-tables i can see my databases. Please help me... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query Cache
Ben Clewett wrote: Hi Mohsen, Thanks for the reply. I'm looking in the home directory, as well as the other directories used by mysql and I can't see any files which I do not recognise. (I am UNIX so there are no hidden files.) I am also a little confuses as the Query Cache is entirely a memory structure, does it use a file? If you have the name of the Query Cache file, this would be very useful. Regards, Ben. Mohsen Pahlevanzadeh wrote: Ben Clewett wrote: Dear MySql, Can you please tell me if there is a tool to view the queries stored in the Query Cache? Regards, Ben Clewett. Yes,If you see to mysql homeDIR,You see a hidden file that it's contain of your queries. Hidden files are started with a dot in UNIX world. If you see them,You must type ls -a --Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query Cache
Ben Clewett wrote: Hi Mohsen, Thanks for the advise. On my AIX system as root, dot files not hidden. For instance my mysql home directory looks like: drwxr-xr-x 16 mysqlmysql 4096 04 Dec 20:18 . drwxr-xr-x 31 root system 4096 09 Nov 15:12 .. drwxr-xr-x 2 mysqlmysql 4096 13 Oct 2005 bin drwxr-xr-x 3 mysqlmysql 256 04 Dec 20:05 etc drwxr-xr-x 2 mysqlmysql 256 13 Oct 2005 info drwxr-xr-x 3 mysqlmysql 256 07 Oct 2005 lib drwxr-xr-x 2 mysqlmysql 256 13 Oct 2005 libexec drwxr-xr-x 3 mysqlmysql 4096 04 Dec 23:50 logs drwxr-xr-x 2 mysqlmysql 256 07 Oct 2005 lost+found drwxr-xr-x 3 mysqlmysql 256 12 Oct 2005 man -rw-rw 1 mysqlstaff 7 04 Dec 20:18 mysql.pid srwxrwxrwx 1 mysqlstaff 0 04 Dec 20:18 mysql.sock drwxr-xr-x 6 mysqlmysql 4096 13 Oct 2005 mysql-test drwxr-xr-x 3 mysqlmysql 256 07 Oct 2005 share drwxr-xr-x 5 mysqlmysql 4096 13 Oct 2005 sql-bench drwxr-xr-x 2 mysqlmysql 256 05 Dec 10:23 tmp There is no file for the Query Cache. I am sure that since this is a memory structure, there must be a command in MySql or an admin tool which can be used to expose the Queries. If anybody knows this really would be very useful. Regards, Ben. Mohsen Pahlevanzadeh wrote: Ben Clewett wrote: Hi Mohsen, Thanks for the reply. I'm looking in the home directory, as well as the other directories used by mysql and I can't see any files which I do not recognise. (I am UNIX so there are no hidden files.) I am also a little confuses as the Query Cache is entirely a memory structure, does it use a file? If you have the name of the Query Cache file, this would be very useful. Regards, Ben. Mohsen Pahlevanzadeh wrote: Ben Clewett wrote: Dear MySql, Can you please tell me if there is a tool to view the queries stored in the Query Cache? Regards, Ben Clewett. Yes,If you see to mysql homeDIR,You see a hidden file that it's contain of your queries. Hidden files are started with a dot in UNIX world. If you see them,You must type ls -a --Mohsen please send me output of following command : grep mysql /etc/passwd Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Migrate
Dear all, I have an ubuntu wiki in that. Now i export my wiki bank,So i dump a 25MG. When i import to my target,it dumps just 4K. My target is RHEL mysql 4.1.20 Please help me... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
migrate
dear all, I wanna dump my wiki bank to a RHEL linux,My source bank is in the ubuntu Linux. My target distro has mysql 4.1.20 When i dump from source,It creates a dump 25MG,But when i export it,it dump 4k only,I have tested it via phpMyAdmin,Mysql_dump webmin. Please help me.. --Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fetching tables
Dears ,I have following code segment: MYSQL_ROW row; ptrm.tblres=mysql_list_tables(ptrm.connection2db,%); cout mysql_num_rows(ptrm.tblres); while (row=mysql_fetch_row(ptrm.tblres)) for (i=0;imysql_num_rows(ptrm.tblres);i++) { cout row[i] endl; } //end for // I need to print name of my tables in my database. I have 3 tables.But it can print 2 tables, for printting of 3th table,it generate a Segment Fault message. Please help me. Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Reading from Mysql writting in PGsql
Dears,I need to read 1 field with select command from mysql.Then Write it to pgsql. Please guide me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
getting type of field
Dears, I need to get type of my field in C. I didn't find a func for it job. Please guide me Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: getting type of field
Oh,No dearm.I wanna retrieve data type of my col. that's right? Mohsen, The info you're looking for is in the 2nd col of the resultset returned by MYSQL_RES * mysql_list_fields (MYSQL *conn, const char *tbl, const char *wild).. Issue a SHOW COLUMS FROM tbl to see all cols returned. Peter Brawley http://www.artfulsoftware.com -- Mohsen Pahlevanzadeh wrote: Dears, I need to get type of my field in C. I didn't find a func for it job. Please guide me Yours,Mohsen -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.5.0 - Release Date: 2/25/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL_FIELD
Dears, My code is : void CMysql::ReadingFld(const char *tblname) { MYSQL_RES *fldres; int i; fldres=mysql_list_fields(connection2db,tblname,%); ptr.srcFldNumber=mysql_num_fields(fldres); FieldsRow=mysql_fetch_fields(fldres); for (i=0;iptr.srcFldNumber;i++) cout FieldsRow[i]; }//end of RedingFld method I defined FieldsRow from MYSQL_FIELD type at my class. Now,I receive following error: [EMAIL PROTECTED] sql2sql]# make g++ -c -I/usr/include -I/usr/include/mysql sql2sql.cpp; sql2sql.cpp: In member function `void CMysql::ReadingFld(const char*)': sql2sql.cpp:208: no match for `MYSQL_FIELD = MYSQL_FIELD*' operator /usr/include/mysql/mysql.h:92: candidates are: st_mysql_field st_mysql_field::operator=(const st_mysql_field) sql2sql.cpp:210: no match for `MYSQL_FIELD [int]' operator make: *** [sql2sql.o] Error 1 Please help me -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Images to MySql Database in PHP or JAVA
Dear member,you can visit: http://dev.mysql.com/doc/connector/j/en/index.html http://dev.mysql.com/doc/mysql/en/php.html Hello list- I am programing both in Java and PHP. Can anyone point me to sample code for either on saving an image to a table? Thanks, -Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL_RES ......
Dear Peter,Thanks for your guiding.I have implemented it.Thank from every member of this list too. Mohsen, The data structure you seem to be looking for is MYSQL_RES, the C API resultset, which is an array which is described in the manual page you were pointed to. It's pretty straightforward to use, eg ... MYSQL_RES *rset; ... if( mysql_real_query( conn, qry, strlen( qry ) == MYSQL_TRUE ) { if(( rset = mysql_store_result( conn )) != NULL ) { cols = mysql_num_fields( rset ); rows = (long) mysql_num_rows( rset ); ...etc... PB - Mohsen Pahlevanzadeh wrote: Dears,I was attempping with your code.But it could't do my job. My job: I have list of my tables in my DB,i did it with mysql_list_tables() func. It returns MYSQL_RES type.But i don't know how to split it to an array. Please guide me.. Hi, I think you can find all the information you are looking for there: http://dev.mysql.com/doc/mysql/en/c.html You have a description of all the functions : http://dev.mysql.com/doc/mysql/en/c-api-functions.html For example: http://dev.mysql.com/doc/mysql/en/mysql-fetch-row.html MYSQL_ROW row; unsigned int num_fields; unsigned int i; num_fields = mysql_num_fields(result); while ((row = mysql_fetch_row(result))) { unsigned long *lengths; lengths = mysql_fetch_lengths(result); for(i = 0; i num_fields; i++) { printf([%.*s] , (int) lengths[i], row[i] ? row[i] : NULL); } printf(\n); } Maybe this is a good start point for you! From: Mohsen Pahlevanzadeh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MYSQL_RES .. Date: Fri, 18 Feb 2005 16:44:06 -0800 (PST) Dears,mysql_list_tables returns name of tables.(tables of a DB) It returns MYSQL_RES type. I want to split it to an array. I'm newbie in SQL,Please guide me. I'm working C. yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/ -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.1.0 - Release Date: 2/18/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MYSQL_RES ......
Dears,I was attempping with your code.But it could't do my job. My job: I have list of my tables in my DB,i did it with mysql_list_tables() func. It returns MYSQL_RES type.But i don't know how to split it to an array. Please guide me.. Hi, I think you can find all the information you are looking for there: http://dev.mysql.com/doc/mysql/en/c.html You have a description of all the functions : http://dev.mysql.com/doc/mysql/en/c-api-functions.html For example: http://dev.mysql.com/doc/mysql/en/mysql-fetch-row.html MYSQL_ROW row; unsigned int num_fields; unsigned int i; num_fields = mysql_num_fields(result); while ((row = mysql_fetch_row(result))) { unsigned long *lengths; lengths = mysql_fetch_lengths(result); for(i = 0; i num_fields; i++) { printf([%.*s] , (int) lengths[i], row[i] ? row[i] : NULL); } printf(\n); } Maybe this is a good start point for you! From: Mohsen Pahlevanzadeh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MYSQL_RES .. Date: Fri, 18 Feb 2005 16:44:06 -0800 (PST) Dears,mysql_list_tables returns name of tables.(tables of a DB) It returns MYSQL_RES type. I want to split it to an array. I'm newbie in SQL,Please guide me. I'm working C. yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Header files data types
Dear Michael, I have found mysql.h.Yes,It is in /usr/include/mysql My code is : CMysql::CMysql() : CCore() { MySQL *x; mysql_connect(x,127.0.0.1,root,); }//end of CMysql constructor My Makefile is : INCS=-I'/usr/include/mysql' #LIBS=-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm #LIBS_R=-L/usr/lib/mysql -lmysqlclient_r -lpthread -lz -lcrypt -lnsl -lm -lpthread #MYSQL_LIBS=-L/usr/lib/mysql -lmysqld -lpthread -lz -lcrypt -lnsl -lm -lpthread -lrt #CXXFLAGS=-march=i486 -mcpu=i686 LIBS=-L'/usr/lib/mysql' -lmysqlclient -lz -lcrypt -lnsl -lm CXX=g++ sql2sql : sql2sql.o $(CXX) $(LIBS) -o sql2sql sql2sql.o ; sql2sql.o : sql2sql.cpp $(CXX) -c $(INCS) core.cpp mysql_engine.cpp sql2sql.cpp; clean : rm -rf sql2sql.o mysql_engine.o core.o // Output of make command is : [EMAIL PROTECTED] sql2sql]# make g++ -c -I'/usr/include/mysql' core.cpp mysql_engine.cpp sql2sql.cpp; mysql_engine.cpp: In constructor `CMysql::CMysql()': mysql_engine.cpp:25: `MySQL' undeclared (first use this function) mysql_engine.cpp:25: (Each undeclared identifier is reported only once for each function it appears in.) mysql_engine.cpp:25: `x' undeclared (first use this function) make: *** [sql2sql.o] Error 1 Please help me . Yours,Mohsen. Depnding on how your mysql was installed, you should have mysql.h on your system somewhere; perhaps in /usr/include/mysql or elsewhere depending on installation parameters.. If not, you can download libraries and headers appropriate to your system version from http://dev.mysql.com/downloads/ On Thu, 2005-02-17 at 13:12, Mohsen Pahlevanzadeh wrote: Dears,I must use data type in C++,same MySQL type. But i don't name of their header files. Please guide me. -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
List of tables.
Dears,Problem of my Makefile is solved. But i have a new problem: I need to create an array of my DB's tables. I have saw mysql_list_tables() function,But it returns a result of sql. Please help me... Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: List of tables.
Dear Peter, I need to name of each table,But mysql_list_tanles() creates a sql result. Can i make an array from those names?Each element of that is a name of table. Please guide me. regards Mohsen, not sure what you mean here, to get a list of tables in a db you have to issue an sql request, which is all mysql_list_tables() does (http://dev.mysql.com/doc/mysql/en/mysql-list-tables.html). PB Mohsen Pahlevanzadeh wrote: Dears,Problem of my Makefile is solved. But i have a new problem: I need to create an array of my DB's tables. I have saw mysql_list_tables() function,But it returns a result of sql. Please help me... Yours,Mohsen -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYSQL_RES ......
Dears,mysql_list_tables returns name of tables.(tables of a DB) It returns MYSQL_RES type. I want to split it to an array. I'm newbie in SQL,Please guide me. I'm working C. yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Data Types in Mysql
Dear,I need to MySQL data type or another. But i dont know name of their header file. Please guide me.. Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Header files data types
Dears,I must use data type in C++,same MySQL type. But i don't name of their header files. Please guide me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
My Problem.Help me
Dears,I have following Makefile : INCS=-I/usr/include/mysql LIBS=-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm LIBS_R=-L/usr/lib/mysql -lmysqlclient_r -lpthread -lz -lcrypt -lnsl -lm -lpthread MYSQL_LIBS=-L/usr/lib/mysql -lmysqld -lpthread -lz -lcrypt -lnsl -lm -lpthread -lrt CXXFLAGS=-march=i486 -mcpu=i686 CXX=g++ sql2sql : sql2sql.o $(CXX) $(LIBS) $(LIBS_R) $(MYSQL_LIBS) -o sql2sql sql2sql.o ; sql2sql.o : sql2sql.cpp $(CXX) -c $(INCS) core.cpp mysql_engine.cpp sql2sql.cpp; clean : rm -rf sql2sql.o mysql.o core.o But when i run make utility,I receive following error: g++ -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -L/usr/lib/mysql -lmysqlclient_r -lpthread -lz -lcrypt -lnsl -lm -lpthread -L/usr/lib/mysql -lmysqld -lpthread -lz -lcrypt -lnsl -lm -lpthread -lrt -o sql2sql sql2sql.o ; /usr/lib/gcc-lib/i486-slackware-linux/3.3.4/../../../../i486-slackware-linux/bin/ld: cannot find -lmysqld collect2: ld returned 1 exit status make: *** [sql2sql] Error 1 My distro is Slackware 10.0 .I didn't add anything to my Linux.It mean i just i don't install everything to my Linux. Please help me.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Makefile my entries.
Dears,I want to add mysql's INCLUDEs LIBs path to my Makefile.in . Of course, i have wizarded a project with KDEvelop.It has created 3 Makefile with .cvs .am .in extensions. Please guide me that i can add mysql_config to them. Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Header files
Dears, I have started Linux-programming with C++. I need to header files's name of MySQL. Please give that's URL. Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Header files
dear member, My problem is name of those.When i wish to apply a function,I don't know name of that's header file.I need to a document for it. --Mohsen On Thursday 10 February 2005 02:06, Logan, David (SST - Adelaide) wrote: Hi Mohsen, If you install the client libraries from http://www.mysql.com for the version you wish, this will install the header files in the mysql/include directory. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mohsen Pahlevanzadeh Sent: Thursday, 10 February 2005 9:00 AM To: mysql@lists.mysql.com Subject: Header files Dears, I have started Linux-programming with C++. I need to header files's name of MySQL. Please give that's URL. Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Slackware10 mysql
Dears,I have slackware10.I install it completely. But when i use /etc/rc.d/rc.mysqld start ,I recieve following mesage : mysql ended Please guide me that i can configure mysql in slack. Yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]