What's wrong with my GRANT example?

2001-06-25 Thread Jochen Wiedmann
Hi, I am sorry for asking stupid questions, but I am at the end of my trials. I simply want to setup a user who can connect from anywhere and write some table and read from another one. Here's what I do: GRANT INSERT, UPDATE, DELETE, SELECT ON sessiondb.SESSION TO dataexport@localhost IDE

Stringifying MySQL C types

2001-06-15 Thread Jochen Wiedmann
Hi, does the MySQL client library contain any support for a proper stringification of the MySQL specific data types like my_ulonglong? IMO they are depending on the operating system and I should not use ltoa() or similar functions. Thanks, Jochen --

Missing symbols in mysqlclient.lib in Win32

2001-05-20 Thread Jochen Wiedmann
Hi, while trying to link the DBD::mysql driver on a Win32 machine I receive the following error message claiming about missing symbols __pctype and ___mb_cur_max in mysqlclient.lib. As you can see from the output below, I am linking against all ".lib" files in the MySQL distribution. The paths a

Re: Trouble automating backup

2001-03-14 Thread Jochen Wiedmann
Duncan Hudson wrote: > $sth_backup = $dbh->prepare("BACKUP table ? TO ?"); You cannot embed table names or column names with the placeholder. If you do, that will not be mapped to BACKUP table foo but to BACKUP table 'foo' which will most probably fail. Use p