Re: problems with perl DBI:DBD mysql

2001-08-31 Thread dwilkers
Hi, I am sure there are cleaner ways, but this works for my scripts just fine. use DBI; $drh=DBI-install_driver('mysql') || warn no Driver\n; $dbh=$drh-connect(search:localhost,user_1) or warn No connect\n; $cursor=$dbh-prepare(select email from opt2 where resend=100); $cursor-execute;

Re: safe_mysql not working properly, can any body help

2001-08-31 Thread dwilkers
Plesae review your log files! On Fri, 31 Aug 2001, nirav shah wrote: Dear friends, I have got mysql current 3.23 version installed with linux in my pc. but it is not working properly when i give command $ safe_mysqld Here after few seconds, it displays

Re: straneg replication problem

2001-08-30 Thread dwilkers
Hi, Every time we have run into this one, is because somthing updating, was out of sync. Best Regards On Thu, 30 Aug 2001, Dave Berk wrote: the master has the correct permission. however the slave reports this error. Slave: Failed reading log event, reconnecting to retry, log

Re: Backing up a MySQL database on a remote server

2001-08-30 Thread dwilkers
Hi, There was allot left un-said:-) assuming you can not get access to the command line dump. select * from your_table_name into outfile your_home_dir/your_filename; This will create a text file. Now download these files and save them. reverse load data infile your_home_dir/your_filename

Re: Error creating database

2001-05-15 Thread dwilkers
I also get somthing like that, much mor productive to do somthing like create database gnudip2(id int(10),some_colum varchar(255)); Trying to show that you add columns with the same command. Darrell On Tue, 15 May 2001, Ana Elisa Martinez wrote: When i try to create a database with the

Re: Can anyone help with a search?

2001-04-24 Thread dwilkers
grep -ir href http_dir |grep -v # |grep -v good links I use somthing like this. Best Regards On Tue, 24 Apr 2001, Alan Halls wrote: Hi, Ok, it is a little off the Mysql topic but I need to know something and I know someone out there can help. I need to do a search on a UNIX box using