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 dis

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->ex

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: 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: Error creating database

2001-05-16 Thread dwilkers
ouch, no idea what I was thinking. Thanks On Wed, 16 May 2001, David Simmons - EliteUKServe.Net wrote: > dont you mean: > > create database gnudip2; > > create table table1 (id int(10),some_colum varchar(255)); > > - Original Message - > From: <[EMAIL PROTECTED]> > To: "Ana Elisa Ma

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 usi