using test database

I am a novice using MySql. I would like to know if and what kind of problem may generate to using de test database of MySql engine (creating tables and data into test database, for example). Thank You Valerio Di Marino VUDIEMME Software www.vdmsoft.com

Re: using test database

Hi Valerio! I am a novice using MySql. I would like to know if and what kind of problem may generate to using de test database of MySql engine (creating tables and data into test database, for example). No problem at all! That's the best way to start learning. Create a database to play

Re: Mysql as backend for email ?!?

Christopher Bergeron writes: Does anyone know of any applications that insert email into mysql databases? I can use either Windows or Linux as the client; however, I want mysql server on the linux box (for stability). I don't like having all of my email in MSOutlook's proprietary format

Re: Mysql List Bounce Message?

Carl Troein writes: Jason Frisvold writes: Can anyone explain why I'm getting a Mail account is disabled message from [EMAIL PROTECTED] regarding anything I post to the mysql list? Yep, that server uses some sort of broken software which mistakes the sender for the receiver or does

new user.

hi there ! can anybody please tell me what is the query to obtain the table strusture ??? TIA Sumit Ranjan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: new user.

Sumit Ranjan writes: hi there ! can anybody please tell me what is the query to obtain the table strusture ??? Heh, sort of you give me the impression of an excited puppy with all those question marks and stuff. Did you try the manual by any chance? Didn't think so.

storing images in MYSQl database

hi , how to store the images in mysql database and how to retrieve the images onto teh VB form.how to do it. please mail me the suggestions. thanx phani = S.V.PHANI KRISHNA STESALIT LIMITED 10,BELVEDERE ROAD, ALIPORE KOLKATTA -

Re: storing images in MYSQl database

phani krishna writes: how to store the images in mysql database and how to retrieve the images onto teh VB form.how to do it. What about it? Lemme guess, you're wondering how to do it, right? Two points: 1) Images are just like any other data. Just store them in a BLOB. As with all other

user creation in mysql

me too facing the problem in creating users and granting permission please help me Hi, We are facing problem with mysql on linux. We are unable to give the password for admin user. Can you please give all the list for installation and user creation as well as for uninstalling? Thanks,

Re: Problem in installing Mysql

Keep reading the istructions expecially the part where it istructs you where to copy the mysql.server. I had the same problem and i still do not know what the @HOSTNAME@ is, however after rebooting the error message still displays but i get a running mysql. harry Kasi Viswanthan Arunachalam

Replication and table locking

Hello I have some questions about MySQL replication and table locking: 1. If I lock a table on the master server, the table will be locked on the slave server? 2. If I use replication, the locking queues are the same on both servers? 3. If my master fails (or I turn off the server) and

Unable to connect to mysql

I was rearranging the stduser permissions to allow it to check passwords stored outside of the standard mysql db. ie adding select permissions. After making changes and right when I clicked reload mysql in phpMyAdmin I received the message stating I was disconnected during query (exact text no

Help - I'm completely locked out of mysql

Hi there, I was trying to modify webmin to enable me to use it to manage mysql and I think I might have modified the root password. I've now spent about 3 hours trawling through the archives and trying all sorts of things, but whatever I do I cannot get into mysql as root (I've attached sample

Help - I'm completely locked out of mysql

mysql Subject: Help - I'm completely locked out of mysql From: Derek Fage [EMAIL PROTECTED] Date: 2001-09-22 14:36:08 [Download message RAW] Hi there, If your forgot yout root password try #/bin/mysql -Skip-grant use mysql;

Re: Compiled v. 3.23.40 and 3.23.42to 12 test Failures

Michael Widenius wrote: Hi! R == R Talbot [EMAIL PROTECTED] writes: R Monty, R Took your advice and downloaded R mysql-3.23.42-pc-linux-gnu-i686.tar.gz R Placed it in /usr/local R Renamed /usr/local/mysql to /usr/local/mysql-old R unpacked with R tar -zxvf

RE: Help - I'm completely locked out of mysql

Hi Bob, Sorry to appear a bit dense, but how do I use the -Skip-grant? I don't see a -Skip-grant option in mysql (mysql --help) Thanks, Derek... -Original Message- From: R Talbot [mailto:[EMAIL PROTECTED]] Sent: 22 September 2001 11:57 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]

Re: Help - I'm completely locked out of mysql

Derek Fage wrote: Hi Bob, Sorry to appear a bit dense, but how do I use the -Skip-grant? I don't see a -Skip-grant option in mysql (mysql --help) Thanks, Derek... -Original Message- From: R Talbot [mailto:[EMAIL PROTECTED]] Sent: 22 September 2001 11:57 To: [EMAIL

Re: Help - I'm completely locked out of mysql

The official answer to your problem can be found in the mysql manual. This could very well be installed on your computer, somewhere (different packaging systems put it in different places, and you may or may not have included the mysql documentation package on your system). Regardless, you can

RE: new user.

Hi, You can use DESCRIBE [TABLE_NAME] or SHOW FIELDS FROM [TABLE_NAME] or SHOW COLUMNS FROM [TABLE_NAME] I suggest you read the manual because this is explained thoroughly in section 6.6.2 http://www.mysql.com/doc/D/E/DESCRIBE.html Regards, Jorge For technical support contracts, visit

RE: Help - I'm completely locked out of mysql

Thanks for that. I had found that in the manual, but as I used /etc/init.d/mysql.server to stop and start mysqld I thought that I needed to pass the --skip-grant-tables to that. I've now found out differently! I seem to have got it cracked now. Many thanks, Derek... -Original

Number of sockets

Hello, how can I set the maximum number of sockets to the database? I didn't find anything for this in my.cnf files and in the MySQL manual. Thanks, Thomas p.s.: mysql-3.23.41 - Before posting, please

graphic interface

Hi all, Is there any graphic tool for controling a Mysql database?. This tool is for a end user that doesn't know anything about sql. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the

Re: graphic interface

You might want to have a look at urSQL -- http://www.urbanresearch.com/ursql or one of the clients listed in the My SQL manual: http://www.mysql.com/doc/S/E/SEC619.html. On Sat, 22 Sep 2001, Pedro Munoz wrote: Hi all, Is there any graphic tool for controling a Mysql database?. This tool is

Iist number of connections/users

What is the command to list all the users connected to mysql server? Thanks Raj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

Michael Widenius wrote: The problem is probably that your tar program doesn't use user-names but user-ids, in which case the files may be owned by 'anyone. What output do you get for: ldd bin/mysqld [root@thinkpad]# ls -l /bin/mysqld -rwxr-xr-x 1 root root 1832912 Sep 21

Re: Compiled v. 3.23.40 and 3.23.42 to12 test Failures

R Talbot wrote: Michael Widenius wrote: The problem is probably that your tar program doesn't use user-names but user-ids, in which case the files may be owned by 'anyone. What output do you get for: ldd bin/mysqld [root@thinkpad]# ls -l /bin/mysqld -rwxr-xr-x 1 root

Re: Iist number of connections/users

Hello Raj! What is the command to list all the users connected to mysql server? Type mysqladmin with no parameters for command line help and a list of options. The one you need is processlist. Have a :) day! jb -- jim barchuk [EMAIL PROTECTED]

Re: Mysql List Bounce Message?

The same for me! The only difference is the domain is some other things else instead of domainhost.com -Jason - Original Message - From: Matt Wagner [EMAIL PROTECTED] To: Carl Troein [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, September 22, 2001 4:14 PM Subject: Re: Mysql

Backup Data

Hello, I currently have about 2500 records in a mySQL database that is hosted with my ISP. I am very familar with MS Access. Is it possible that I can backup my data into a MS Access database ? Any advice would be very grateful ! Thanks Neil www.advertising-online.net

RE: Backup Data

There are two methods that I commonly use to move data from mySql into Access. The first is to use a myODBC connection and simply import the tables. Given the size of your database (small that is) this would be quite quick assuming that you are able to establish an ODBC connection to your

Re: Backup Data

Thanks for your reply. What about replication ? I've looked at this, but everyone says read the manual. I would like to hear from someone who has had experience with this and does it work correctly. For example has anyone had a database online with a ISP and updated a local copy locally with

RE: Backup Data

I have experimented only with replication. All of my experimentation has been on two machines on the same physical network. I quickly determined that replication was not going to be a good solution for what I wanted: An always available inquiry server (free from lock conflicts caused by long

UPDATE or 'rewrite' table with SELECT?

My project has one table that is a list of keywords that apply to another table Locations. At intervals I will run a script to count the number of records in Locations that each keyword uses and store that number in the Keywords table, so that I can show users how many locations each keyword

mysql_safe keeps restarting

When I start mysql with the following command is restarts constantly: /usr/local/mysql/bin/safe_mysql --user=mysql the following message scrolls constantly date time mysqld restarted Anyone provide any help? At the time this began I was editing permissions for the stduser so it can check

Functions as default values

Timestamp is a useful datatype when you want to register when a record changed. Now I want to register who changed it and tried to use user() as a default value and my database just returned user() as the field value. Is there someone who can tell me how to use a function result as default

Re: Compiled v. 3.23.40 and 3.23.42 to 12 test Failures

On Friday 21 September 2001 10:54, R Talbot wrote: Sasha Pachev wrote: On Thursday 20 September 2001 20:37, R Talbot wrote: My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1 being too old but how muc trouble is it to upgrade.the LIB V. 3.23.40 is running but

Primary Key Issue while importing BIN Logs

I'm having a difficult time synchronizing my Master and Slave Servers. I've been doing this using MySQL Binary Logs, where the Master rotates the logs at 1 hour times, and the slave downloads it and imports it. What happens why I try to pipe the binlog into mysql is that it reports and error

table stuck in read only

Can anyone explain this to me? Why can I not alter this table? SQL-query : [Edit] ALTER TABLE `CustomerInfo`ORDER BY `CustID` MySQL said: Table 'CustomerInfo' is read only or SQL-query : [Edit] INSERT INTO `CustomerInfo` (`CustID`, `FirstName`, `LastName`, `Address1`, `Address2`, `City`,

Still about WinMySqladmin and MySqlManager

Hello again... Sorry I ask again, are there complete tutor about WinMySqladmin and MySqlmanager, expecially to Miguel A. Solarzo Thanks Regard Feny Soeha --- Runbox Mail Manager - www.runbox.com Online email application

Re: Still about WinMySqladmin and MySqlManager

At 22:50 22/09/01 +, [EMAIL PROTECTED] wrote: Hi! Hello again... Sorry I ask again, are there complete tutor about WinMySqladmin and MySqlmanager, expecially to Miguel A. Solarzo Thanks If you want to know how to use the WinMySQLAdmin, you can see the help file at \mysql\bin directory. If

MySQL and PHP problem

Had a fully working installation of MySQL 3.23 with PHP 6.0.6. I then foolishly installed PGP which included PGPNet and I cant access my MySQL database from PHP. When I try to connect I get error '', another strange thing is under MyODBC it says 'Not Found'. I have re-installed both PHP

MySQL and PHP problem

[Reposting cos left error message out, sorry] Had a fully working installation of MySQL 3.23 with PHP 6.0.6. I then foolishly installed PGP which included PGPNet and I cant access my MySQL database from PHP. When I try to connect I get error 'Access denied for user: '@GREEN' to database

RE: Select dates from Table 1 not in Table 2

Thanks Will for the suggestion, however as per my private email to you, it didn't work successfully to any degree. Actually it knocked out ONE date from the same group and that was one of the Available dates. I have created a tmp_table for use, for some reason I can't create TEMPORARY tables

mysqlgui Help Help

Dear Users, How do I configure mysqlgui to activate the Help-Contents option in the menu? I have installed mysqlgui in the \mysql\bin directory. The my.cnf.win (configuration file) and mysql.help files are in the same directory as the mysqlgui executable. I am running mysql on Windows98. What

Not working mysql in win2000 Prof.

Dear Sir, I have window 2000 Professional Operating System. Ihad installed PHP, Apache Web Server and MySql.PHP worksvery good with apache. MySql is installed in by deafaul directory that is c:\mysql but MySql does not work.I aslso create the file c:\MY.CNF with document of My-example.cnf.