Re: MySQL & My program

2006-12-30 Thread Mohsen Pahlevanzadeh
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" da

Re: MySQL & My program

2006-12-28 Thread Mohsen Pahlevanzadeh
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 database

MySQL & My program

2006-12-28 Thread Mohsen Pahlevanzadeh
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 --

Re: Query Cache

2006-12-05 Thread Mohsen Pahlevanzadeh
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

Re: Query Cache

2006-12-05 Thread Mohsen Pahlevanzadeh
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?

migrate

2006-10-28 Thread Mohsen Pahlevanzadeh
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.. --Mohs

Migrate

2006-10-28 Thread Mohsen Pahlevanzadeh
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://list

Fetching tables

2005-02-28 Thread Mohsen Pahlevanzadeh
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;ihttp://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Reading from Mysql & writting in PGsql

2005-02-27 Thread Mohsen Pahlevanzadeh
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]

Re: getting type of field

2005-02-25 Thread Mohsen Pahlevanzadeh
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,Mo

getting type of field

2005-02-25 Thread Mohsen Pahlevanzadeh
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: Images to MySql Database in PHP or JAVA

2005-02-23 Thread Mohsen Pahlevanzadeh
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 Genera

MYSQL_FIELD

2005-02-23 Thread Mohsen Pahlevanzadeh
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;ihttp://lists.mysql.com/mysql To unsubscribe:http:

Re: MYSQL_RES & ......

2005-02-20 Thread Mohsen Pahlevanzadeh
ed 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++) >>> { >&g

RE: MYSQL_RES & ......

2005-02-19 Thread Mohsen Pahlevanzadeh
f("[%.*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: [EMAI

MYSQL_RES & ......

2005-02-18 Thread Mohsen Pahlevanzadeh
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://lis

Re: List of tables.

2005-02-18 Thread Mohsen Pahlevanzadeh
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 D

List of tables.

2005-02-18 Thread Mohsen Pahlevanzadeh
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 T

Re: Header files & data types

2005-02-18 Thread Mohsen Pahlevanzadeh
r 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 dyk

Header files & data types

2005-02-17 Thread Mohsen Pahlevanzadeh
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]

Data Types in Mysql

2005-02-17 Thread Mohsen Pahlevanzadeh
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]

My Problem.Help me

2005-02-13 Thread Mohsen Pahlevanzadeh
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

Makefile & my entries.

2005-02-10 Thread Mohsen Pahlevanzadeh
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

Re: Header files

2005-02-09 Thread Mohsen Pahlevanzadeh
8 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

2005-02-09 Thread Mohsen Pahlevanzadeh
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]

Slackware10 & mysql

2005-01-25 Thread Mohsen Pahlevanzadeh
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: