RE: Database Dump
Swati, You can also use mysqldump to be part of the mechanism to move the database(s) from one computer to another. Something like: Prompt mysqldump --add-drop-table databasename -uuserid -ppassword | mysql --host=your.new.host.IP databasename -uuserid -ppassword -Original Message- From: Swati K [mailto:[EMAIL PROTECTED] Sent: Saturday, November 15, 2003 5:41 AM To: [EMAIL PROTECTED] Subject: Database Dump Hi All I have just started working on MYSQL. Can ne one help on How to take a database Backup? and how does one transfer the MYSQL database from one Comp to another one? Regards Swati kalia http://www.mecklai.com where risk meets its match *** This message is intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Backup question.
Yes, you can do it like this: Prompt mysqldump --add-drop-table --host=source.IP.addr.spec -uuser -ppassword databasename | mysql -uuser -ppassword I've found that it helps things if you add --no-data to the source side on the first pass, then remove that clause and run it again. Dave -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:54 PM To: [EMAIL PROTECTED] Subject: Backup question. I would like to backup databases from a linux MySQL server to another linux machine on the same private network but I don' see in the docs how I can do this with mysqlhotcopy or mysqldump. Is there any way to do this besides using ftp. Any help would be appreicated. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Windows to Linux
If you can mount the Windows partitions under LINUX, you can copy file files from partition to partition. If that's not possible, you'll have to export the data under Windows to another location/media, then boot into LINUX and load the data into your LINUX database. You can dump the databases from the Windows edition by using: Mysqldump --all-databases --add-drop-table -uuserid -ppassword mydumpfilename.sql To reload you can then: Mysql -uusername -ppassword mydumpfilename.sql -Original Message- From: Matt Fletcher [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2003 6:51 PM To: [EMAIL PROTECTED] Subject: Windows to Linux Hi there, I have taken the plunge and dropped windows in favour of linux. My question is what is the best way to get the data from my windows mysql databases into linux? Can I just copy some files from one partition to another or what? Thanks, Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: I can't start mysqld
In the data directory for MySQL, you should find a file titled hostname.err. What is the contents of that file? -Original Message- From: Hamid Nouri [mailto:[EMAIL PROTECTED] Sent: Saturday, October 18, 2003 5:07 PM To: [EMAIL PROTECTED] Subject: I can't start mysqld Hi there I have a problem with starting mysqld. I tried to install mysql-4.1 on my debian, but when i want to start mysql daemon it failes. I generated bug report. my.cnf and mysql also attached. Thanks in advance - SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: root To: [EMAIL PROTECTED] Subject:synopsis of the problem (one line) Description: precise description of the problem (multiple lines) How-To-Repeat: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-4.1.0-alpha-standard (Official MySQL-standard binary) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: machine, os, target, libraries (multiple lines) System: Linux pinguin 2.4.18-bf2.4 #1 Son Apr 14 09:53:28 CEST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 3 13:31 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153784 Apr 28 2002 /lib/libc-2.2.5.so -rw-r--r--1 root root 2390922 Apr 28 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 28 2002 /usr/lib/libc.so -rw-r--r--1 root root 716080 Jan 13 2002 /usr/lib/libc-client.so.2001 Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL-standard binary' '--with-extra-charsets=complex' '--with-server-suffix=-standard' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-client-ldflags=-all-static' '--with-mysqld-ldflags=-all-static' '--with-innodb' 'CFLAGS=-O2 -mcpu=pentiumpro' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' 'CXX=gcc' my.cnf--- # You can copy this to one of: # /etc/mysql/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password = my_password port= 3306 socket = /var/run/mysqld/mysqld.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram [safe_mysqld] err-log = /var/log/mysql/mysql.err [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port= 3306 # # You can also put it into /var/log/mysql/mysql.log but I leave it in /var/log # for backward compatibility. Both location gets rotated by the cronjob. #log= /var/log/mysql/mysql.log log = /var/log/mysql.log basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language= /usr/share/mysql/english skip-locking # # The skip-networkin option will no longer be set via debconf menu. # You have to manually change it if you want networking i.e. the server # listening on port 3306. The default is disable - for security reasons. skip-networking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K # # Here you can see queries with especially long duration #log-slow-queries = /var/log/mysql/mysql-slow.log # # The following can be used as easy to replay backup logs or for replication #server-id = 1 #log-bin= /var/log/mysql/mysql-bin.log #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name # # Read the manual if you want to enable InnoDB! skip-innodb [mysqldump] quick set-variable=
RE: mysqldump ?
Are you attempting any sort of editing of the exported file? We routinely dump our production database, which includes several tables that hold TIF images, with no problems at all. In fact, we'll also transfer data between servers with a command like: Mysqldump --add-drop-table databasename -uroot -ppassword | mysql --host=otherIPaddress -uroot -ppassword IN addition, we'll also dump to text files with no problem at all. This is a part of our daily backup and has worked for data restore/loading on several servers, both LINUX and Windows. The only time we've had problems is if I would try to edit the file, the editor would truncate the text lines containing the blob data which would then create corrupted images. -Original Message- From: Terry Cheryl Haimann [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 11:11 AM To: mysql Subject: mysqldump ? I have a mysql 3.23 running under win98. I also have a database with a largeblob, which has a jpeg image in it. Now I am trying to upload this to a free server using the following command to export the table: bin/mysqldump -u user --password=mypass mydatabase mytable dumpdir\mytable.sql The jpegs are becoming corrupted, I know it is happening in the mysqldump program. Because, I have a rh 8.0 box running mysql 3.23 and if I issue the following command: mysql -u user --password=mypass mydatabase mytable.sql All of the data is ok except for the blobs which are corrupted. I also tryed exporting it as: bin/mysqldump -u user --password=mypass --quick mydatabase mytable dumpdir\mytable.sql But the data was still corrupted. Any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Getting the value of a row you just inserted
Here's the link to the on-line manual page that will help you. http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html -Original Message- From: Dan Anderson [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 5:06 PM To: [EMAIL PROTECTED] Subject: Getting the value of a row you just inserted Is it possible to SELECT the id (indexed PRIMARY KEY AUTO_INCREMENT) of a row that was just inserted? I'm using PHP, I don't know if that makes a difference? Something like: INSERT INTO foo (bar) VALUES (bar); SELECT last_insert(id) FROM foo; Also, are there any problems with using this in an environment where you're forking processes? Thanks in advance, -Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: how to export data from multiple tables
What machines are you working with at each end? Internal network? -Original Message- From: Nitin [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 10:19 AM To: Andy Eastham; Mysql List Subject: Re: how to export data from multiple tables any idea, how to export data to a file on the remote machine? thanx for the help anyway Nitin - Original Message - From: Andy Eastham [EMAIL PROTECTED] To: Mysql List [EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 9:49 PM Subject: RE: how to export data from multiple tables Nitin, Create a temporary table, then select each table into it in turn, then output that to the file? Andy -Original Message- From: Nitin [mailto:[EMAIL PROTECTED] Sent: 07 October 2003 11:40 To: [EMAIL PROTECTED] Subject: how to export data from multiple tables Hi all, I've got a small problem (hope it's very small). Could any of you suggest me how to select my data into a simple text file from multiple tables (selected with union)! I've tried: select field-list into outfile filename from table1 union select field-list into outfile filename from table2 union select field-list into outfile filename from table3 It says check your version manualblah blah Any idea, how to do it? Thanx in advance Nitin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: printing reports
You can, via ODBC, connect to MySQL using OpenOffice or Star Office which would give you a no-cost, or low-cost, option for producing reports from MySQL. There are a number of execellent web articles about interfacing either of these with MySQL. Try searching via Google. -Original Message- From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 9:49 AM To: Wang Feng; [EMAIL PROTECTED] Subject: Re: printing reports To get data from/into MySQL, you will always need a client software. So, the reporting thing should be implemented in your client software. Hope to be right!!! Thanks Emery - Original Message - From: Wang Feng [EMAIL PROTECTED] To: Wang Feng [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 12:22 Subject: Re: printing reports In MySQL, how can I create and print reports without the help of neither a scripting language(e.g. php) nor a thrid party software tool? bad grammar :-( but you guys understand what i'm saying, right? :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help With a DATETIME Query
I've worked on applications like this one in a court scheduling application. Since trials can run several days, this was an issue I had to deal with, too. The solution I set up was to have a table like your bookings table, then have another table containing available time slots for each eligible date. At the time a booking was created, my application then reserved appropriate time slots in the adjacent table for that particular booking row. The key is that the timeslots table had rows for each day involved and made subsequent queries much easier and more accurate. This one is my .02... :-) -Original Message- From: shaun thornburgh [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 3:51 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Help With a DATETIME Query Thanks for your reply, but its not an option! From: Dan Greene [EMAIL PROTECTED] To: shaun thornburgh [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Help With a DATETIME Query Date: Tue, 7 Oct 2003 16:41:04 -0400 I know it's not the answer you're looking for... :( but dealing with overnights has caused me so much aggravation in past apps I've written, I've tended to make the client create two (or more) 'bookings' for the covered time... don't know if it's an option for you, but it's my $0.02. -Original Message- From: shaun thornburgh [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 4:33 PM To: [EMAIL PROTECTED] Subject: Help With a DATETIME Query Hi, I have a table called Bookings which has two important columns; Booking_Start_Date and Booking_End_Date. These columns are both of type DATETIME. The following query calculates how many hours are available between the hours of 09.00 and 17.30 so a user can see at a glance how many hours they have unbooked on a particular day (i.e. 8.5 hours less the time of any bookings on that day). However, when a booking spans more than one day the query doesn't work, for example if a user has a booking that starts on day one at 09.00 and ends at 14.30 on the next day, the query returns 3.5 hours for both days. The query is run for each day i.e day 1, day 2 day 10. Any help here would be greatly appreciated. SELECT 8.5 - (SUM(((DATE_FORMAT(B.Booking_End_Date, '%k') * 60 ) + DATE_FORMAT(B.Booking_End_Date, '%i')) - ((DATE_FORMAT(B.Booking_Start_Date, '%k') * 60 ) + DATE_FORMAT(B.Booking_Start_Date, '%i'))) / 60) AS Available_Hours FROM WMS_Bookings B WHERE B.User_ID = '16' AND B.Booking_Status '1' AND NOT ( '2003-10-07' DATE_FORMAT(Booking_Start_Date, %Y-%m-%d) OR '2003-10-07' DATE_FORMAT(Booking_End_Date, %Y-%m-%d) ) _ On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] _ Use MSN Messenger to send music and pics to your friends http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Install question Linux RPMs
You're going to have to see where the files were installed. It was easier with Red Hat 7.3 because the Kpackage program would tell you where the files were installed. I don't know how you find that info out with Red Hat 8.0 or 9.0. -Original Message- From: Harrell, Roger [mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 4:56 PM To: '[EMAIL PROTECTED]' Subject: Install question Linux RPMs I am installing MySQL 4.0.15 on Red Hat Linux 8. I ran the rpms for server and client. It installed and started mysqld but none of the command set seems to be on the system anywhere. No mysql, mysqladmin, etc. The docs don't give much help after running the rpms. After secton 2.1.2 it refers to section 2.4 Post-installation Setup and Testing. This section does not talk about steps after running rpm -i on the server and client package. I can't figure out what occurred. Has anyone experienced this before, or have ideas on how to troubleshoot? Thanks, Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Unable to Create DB Connection
Did you set up a my.ini file in your Windows directory? If so, what is in the file? -Original Message- From: Scott D. Spiegler [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 10:24 AM To: Christensen, Dave; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: Unable to Create DB Connection Oh, right- I forgot to mention that. Part of the error message in trying to connect to the database said that it couldn't find the mysql.err file. I installed mySQL in C:\mysql but the error message from the DOS shell said it couldn't find the file: D:\mysql\data\english\mysql.err. I am not sure why it was looking for that file on the D drive when I expected it to look on C:\mysql\data\english\mysql.err. That may not be the precise path that I am quoting, but - let's assume it is for a minute- the message was confusing in that mySQL was looking for that file on my D drive, when the application is installed on C. Is there some way to tell mySQL to look in the a path of the C drive? Thanks, Scott --- Christensen, Dave [EMAIL PROTECTED] wrote: Scott, You should be able to find a file titled 'mysql.err' in your data directory. This file will contain information that should help you get started. -Original Message- From: Scott D. Spiegler [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:59 AM To: [EMAIL PROTECTED] Subject: Unable to Create DB Connection Hi, I am using the binary distribution of mySQL for Windows-2000 and am not able to connect to the DBserver. I used the Setup executable to install the application. I verified that the my.ini file was created and contained appropriate information. But, when I right-click with my mouse on the stop light icon- to start the service- nothing happens. I tried to ping the port that mySQL was supposed to be listening at, and it said that the connection was refused. So, it seems like I have not done something properly. Any thoughts as to how to trouble shoot this problem? Thanks, Scott = Scott D. Spiegler President Innovative Technical Solutions Pawtucket, RI 02861 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] = Scott D. Spiegler President Innovative Technical Solutions Pawtucket, RI 02861 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: installation question...missing 'host.frm'
Craig, Errno 13 indicates that you have some permission issues. Check the data directories you've set up to make sure that they are owned by the user/group mysql. -Original Message- From: Craig A. Finseth [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 1:42 PM To: [EMAIL PROTECTED] Subject: installation question...missing 'host.frm' I am trying to install: mysql-standard-4.0.14-sun-solaris2.8-sparc.tar on a Solaris 8 system. I am getting this message in the .err file: 030910 11:05:41 mysqld started 030910 11:05:41 InnoDB: Started 030910 11:05:41 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 030910 11:05:41 Aborting I haven't been able to find any reference to that file in any of the MySQL documentation. I've tried creating such a file, but the message remains unchanged. I am doing a little weird install. The commands and scripts go into /usr/local/bin and the database lives in /local/mysql. I have added symbolic cross links. Anyone have any ideas? Craig A. Finseth[EMAIL PROTECTED] Firwood Consulting, Inc.[EMAIL PROTECTED] 1343 Lafond, St Paul MN 55104 +1 651 644 4027 USA http://www.firwood.net +1 651 644 4027 fax (yes, same number) A ship is safe in a harbor, but that's not what a ship is for--Adm Grace Hopper -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Unable to Create DB Connection
Scott, You should be able to find a file titled 'mysql.err' in your data directory. This file will contain information that should help you get started. -Original Message- From: Scott D. Spiegler [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:59 AM To: [EMAIL PROTECTED] Subject: Unable to Create DB Connection Hi, I am using the binary distribution of mySQL for Windows-2000 and am not able to connect to the DBserver. I used the Setup executable to install the application. I verified that the my.ini file was created and contained appropriate information. But, when I right-click with my mouse on the stop light icon- to start the service- nothing happens. I tried to ping the port that mySQL was supposed to be listening at, and it said that the connection was refused. So, it seems like I have not done something properly. Any thoughts as to how to trouble shoot this problem? Thanks, Scott = Scott D. Spiegler President Innovative Technical Solutions Pawtucket, RI 02861 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
External Access
This may seem like a stupid question, but I haven't been able to track down an answer yet. We're going to try to access a remote MySQL server that is protected behind a firewall. I know that we need to open a port, such as 3306, to access the server. My question is whether that port requires TCP, UDP or both to be open. Thanks! David Christensen Brokers International, Ltd. 1200 E Main St Panora, IA 50216 (641) 755-2775 [EMAIL PROTECTED]
Odd thing
We're trying to set up some scripts that will run mysqldump to create export files for each table in a database that can be downloaded to a test server and reloaded. What's weird is that the files are created with the ? character as the trailing character in the file name and we can't open them to do anything with the files. David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Additional info.
The server (our development test server) is running Red Hat 8.0 and Mysql 4.1. The remote test server to which we're trying to transfer data is running Red Hat 7.3 and Mysql 4.013. David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Odd thing
Just creating shell scripts with one line creating each file. This is our first attempt to see how working with the smaller files performs while transferring data between sites. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:43 AM To: Christensen, Dave; [EMAIL PROTECTED] Cc: Dickey, Dallas Subject: RE: Odd thing [snip] We're trying to set up some scripts that will run mysqldump to create export files for each table in a database that can be downloaded to a test server and reloaded. What's weird is that the files are created with the ? character as the trailing character in the file name and we can't open them to do anything with the files. [/snip] How are your creating them? Script language? Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Odd thing
Yes, we'd be creating the file on a Windows box, then transferring the file to either a Samba share or using FTP to the LINUX machine. -Original Message- From: Matthew Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:54 AM To: Christensen, Dave; 'Jay Blanchard'; [EMAIL PROTECTED] Cc: Dickey, Dallas Subject: RE: Odd thing Hi, are you using MSDOS/Windows anywhere here - it might be a trailing ^M which Windows uses before ^J as the end of line character. Regards Matthew -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: 19 June 2003 15:50 To: 'Jay Blanchard'; '[EMAIL PROTECTED]' Cc: Dickey, Dallas Subject: RE: Odd thing Just creating shell scripts with one line creating each file. This is our first attempt to see how working with the smaller files performs while transferring data between sites. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 9:43 AM To: Christensen, Dave; [EMAIL PROTECTED] Cc: Dickey, Dallas Subject: RE: Odd thing [snip] We're trying to set up some scripts that will run mysqldump to create export files for each table in a database that can be downloaded to a test server and reloaded. What's weird is that the files are created with the ? character as the trailing character in the file name and we can't open them to do anything with the files. [/snip] How are your creating them? Script language? Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Odd thing
--disable-keys AgentAdminDB shippingtypelookup -uroot -ppano4577 shippingtypelookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB stateidlookup -uroot -ppano4577 stateidlookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB statuslookup -uroot -ppano4577 statuslookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB subactivitylookup -uroot -ppano4577 subactivitylookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB timezonelookup -uroot -ppano4577 timezonelookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB usergrouplookup -uroot -ppano4577 usergrouplookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB users -uroot -ppano4577 users.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB usertypelookup -uroot -ppano4577 usertypelookup.sql + -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Thursday, June 19, 2003 10:10 AM To: Dickey, Dallas; Christensen, Dave; [EMAIL PROTECTED] Subject: RE: Odd thing [snip] mysqldump AgentAdminDB activitylookup -u UserName -pPassword //var/data/mysql/activitylookup.sql mysqldump AgentAdminDB agencies -u UserName -pPassword //var/data/mysql/agencies.sql mysqldump AgentAdminDB agentdocuments -u UserName -pPassword //var/data/mysql/agentdocuments.sql mysqldump AgentAdminDB agentdownlink -u UserName -pPassword //var/data/mysql/agentdownlink.sql mysqldump AgentAdminDB agentnotes -u UserName -pPassword //var/data/mysql/agentnotes.sql mysqldump AgentAdminDB agentpages -u UserName -pPassword //var/data/mysql/agentpages.sql [/snip] Can we see the rest of the script? Jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Odd thing
When I run this script file, I receive errors like this: [EMAIL PROTECTED] work]# ./BackupByTable.bat mysqldump: Got error: 1146: Table 'AgentAdminDB.MissedPages' doesn't exist when doing LOCK TABLES -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:58 AM To: 'Jay Blanchard'; Dickey, Dallas; Christensen, Dave; '[EMAIL PROTECTED]' Subject: RE: Odd thing I've also tried creating the script manually (script follows) and all that's being created is a text header with nothing else in the file. At least in these instances we can use the text files. Just be nice if they were valid... :-) --- Here's the script mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB MissedPages -uroot -ppano4577 MissedPages.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_APP_INFO -uroot -ppano4577 UCS_APP_INFO.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_AUDIT -uroot -ppano4577 UCS_AUDIT.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_COMPS -uroot -ppano4577 UCS_COMPS.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_FORMS -uroot -ppano4577 UCS_FORMS.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_HISTORY -uroot -ppano4577 UCS_HISTORY.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_LOGIN_TRACE -uroot -ppano4577 UCS_LOGIN_TRACE.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_PACCESS -uroot -ppano4577 UCS_PACCESS.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_PROFILES -uroot -ppano4577 UCS_PROFILES.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_UACCESS -uroot -ppano4577 UCS_UACCESS.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_USERINFO -uroot -ppano4577 UCS_USERINFO.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_USERS -uroot -ppano4577 UCS_USERS.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB activitylookup -uroot -ppano4577 activitylookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agencies -uroot -ppano4577 agencies.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agentdocuments -uroot -ppano4577 agentdocuments.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agentdownlink -uroot -ppano4577 agentdownlink.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agentnotes -uroot -ppano4577 agentnotes.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agentpages -uroot -ppano4577 agentpages.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agents -uroot -ppano4577 agents.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agentsdba -uroot -ppano4577 agentsdba.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB airlinelookup -uroot -ppano4577 airlinelookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB airportlookup -uroot -ppano4577 airportlookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB appointments -uroot -ppano4577 appointments.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB appointmentstatuslookup -uroot -ppano4577 appointmentstatuslookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB appointmenttypelookup -uroot -ppano4577 appointmenttypelookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB appointmentuplink -uroot -ppano4577 appointmentuplink.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB appversioninfo -uroot -ppano4577 appversioninfo.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB callstatuslookup -uroot -ppano4577 callstatuslookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB carriercontacts -uroot -ppano4577 carriercontacts.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB carriernotes -uroot -ppano4577 carriernotes.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB carriers -uroot -ppano4577 carriers.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB contactnotes -uroot -ppano4577 contactnotes.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB contacts -uroot
RE: Odd thing
Oops! Sorry. Deleted that 'temp' table and didn't remove it from my script file. -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:34 AM To: 'Jay Blanchard'; Dickey, Dallas; '[EMAIL PROTECTED]' Subject: RE: Odd thing Importance: High When I run this script file, I receive errors like this: [EMAIL PROTECTED] work]# ./BackupByTable.bat mysqldump: Got error: 1146: Table 'AgentAdminDB.MissedPages' doesn't exist when doing LOCK TABLES -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:58 AM To: 'Jay Blanchard'; Dickey, Dallas; Christensen, Dave; '[EMAIL PROTECTED]' Subject: RE: Odd thing I've also tried creating the script manually (script follows) and all that's being created is a text header with nothing else in the file. At least in these instances we can use the text files. Just be nice if they were valid... :-) --- Here's the script mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB MissedPages -uroot -ppano4577 MissedPages.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_APP_INFO -uroot -ppano4577 UCS_APP_INFO.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_AUDIT -uroot -ppano4577 UCS_AUDIT.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_COMPS -uroot -ppano4577 UCS_COMPS.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_FORMS -uroot -ppano4577 UCS_FORMS.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_HISTORY -uroot -ppano4577 UCS_HISTORY.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_LOGIN_TRACE -uroot -ppano4577 UCS_LOGIN_TRACE.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_PACCESS -uroot -ppano4577 UCS_PACCESS.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_PROFILES -uroot -ppano4577 UCS_PROFILES.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_UACCESS -uroot -ppano4577 UCS_UACCESS.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_USERINFO -uroot -ppano4577 UCS_USERINFO.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_USERS -uroot -ppano4577 UCS_USERS.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB activitylookup -uroot -ppano4577 activitylookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agencies -uroot -ppano4577 agencies.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agentdocuments -uroot -ppano4577 agentdocuments.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agentdownlink -uroot -ppano4577 agentdownlink.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agentnotes -uroot -ppano4577 agentnotes.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agentpages -uroot -ppano4577 agentpages.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agents -uroot -ppano4577 agents.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB agentsdba -uroot -ppano4577 agentsdba.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB airlinelookup -uroot -ppano4577 airlinelookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB airportlookup -uroot -ppano4577 airportlookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB appointments -uroot -ppano4577 appointments.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB appointmentstatuslookup -uroot -ppano4577 appointmentstatuslookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB appointmenttypelookup -uroot -ppano4577 appointmenttypelookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB appointmentuplink -uroot -ppano4577 appointmentuplink.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB appversioninfo -uroot -ppano4577 appversioninfo.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB callstatuslookup -uroot -ppano4577 callstatuslookup.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB carriercontacts -uroot -ppano4577 carriercontacts.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB carriernotes -uroot -ppano4577 carriernotes.sql mysqldump --add-drop-table --compatible=mysql323
RE: Odd thing
Gerald, That may be a preference, but the scripts typically run on the LINUX command line just fine in the form that we've entered. We've been entering them in that manner for months with no operational issues. Thanks for the input though. Have a great day! Dave -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 12:19 PM To: Christensen, Dave Cc: '[EMAIL PROTECTED]' Subject: Re: Odd thing Christensen, Dave wrote: Oops! Sorry. Deleted that 'temp' table and didn't remove it from my script file. -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 11:34 AM To: 'Jay Blanchard'; Dickey, Dallas; '[EMAIL PROTECTED]' Subject: RE: Odd thing Importance: High When I run this script file, I receive errors like this: [EMAIL PROTECTED] work]# ./BackupByTable.bat mysqldump: Got error: 1146: Table 'AgentAdminDB.MissedPages' doesn't exist when doing LOCK TABLES -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 10:58 AM To: 'Jay Blanchard'; Dickey, Dallas; Christensen, Dave; '[EMAIL PROTECTED]' Subject: RE: Odd thing I've also tried creating the script manually (script follows) and all that's being created is a text header with nothing else in the file. At least in these instances we can use the text files. Just be nice if they were valid... :-) --- Here's the script mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB MissedPages -uroot -ppano4577 MissedPages.sql mysqldump --add-drop-table --compatible=mysql323 --disable-keys AgentAdminDB UCS_APP_INFO -uroot -ppano4577 UCS_APP_INFO.sql You have options after the tables. All options should precede the database and tables. mysqldump --add-drop-table --compatible-mysql323 --disable-keys -uroot -ppano4577 AgentAdminDB MissedPages MissedPages.sql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.1 and MyCC
I upgraded my test MySQL server yesterday to 4.1 and I'm now receiving an error when I try to connect using MyCC. The error is ERROR 1249: Client does not support authentification protocol requested by server. Consider upgrading MySQL client. I've tried to find a solution on the website, but either it's not mentioned there or my search skills need some refinement (probably the latter :-) Anyone have any idea what I have to do to solve this one? David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL 4.1 and MyCC
Don't know if I agree with that. I can connect via VPN to a test server at the home office running RH 8.0 and MySQL 4.1. I can also connect to a RH 7.3 machine running MySQL 4.0.12. BUT I can't connect to my local test server running Red Hat 7.3 and MySQL 4.1 without receiving the error message. -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 1:30 PM To: Christensen, Dave Subject: Re: MySQL 4.1 and MyCC MyCC does not support MySQL 4.1 coz the the library to connect to MySQL 4.1 has changed. Karam --- Christensen, Dave [EMAIL PROTECTED] wrote: I upgraded my test MySQL server yesterday to 4.1 and I'm now receiving an error when I try to connect using MyCC. The error is ERROR 1249: Client does not support authentification protocol requested by server. Consider upgrading MySQL client. I've tried to find a solution on the website, but either it's not mentioned there or my search skills need some refinement (probably the latter :-) Anyone have any idea what I have to do to solve this one? David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL 4.1 and MyCC
Tried this and it didn't make any difference. Still getting the error when I try to connect to the server with MyCC. I CAN connect using the command line mysql program. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 5:08 PM To: Peter Burden Cc: Christensen, Dave; '[EMAIL PROTECTED]' Subject: Re: MySQL 4.1 and MyCC At 23:18 +0100 6/11/03, Peter Burden wrote: Paul DuBois wrote: At 11:55 -0500 6/11/03, Christensen, Dave wrote: I upgraded my test MySQL server yesterday to 4.1 and I'm now receiving an error when I try to connect using MyCC. The error is ERROR 1249: Client does not support authentification protocol requested by server. Consider upgrading MySQL client. I've tried to find a solution on the website, but either it's not mentioned there or my search skills need some refinement (probably the latter :-) Anyone have any idea what I have to do to solve this one? Start the server with the --old-passwords option. Or put this in an option file: [mysqld] old-passwords Thanks - that also answers an earlier post of mine - although I think it should be old-password and if you've (as I did) set up 4.1 with new style passwords, you can't then just drop this into /etc/my.cnf without also changing all the passwords - the new and old schemes encrypt in a different way AFAIK. Actually, the option *is* --old-passwords (with an s), though probably the option processor will recognize both. Also, if you have set up 4.1 accounts with new passwords, you can still connect to those accounts, even with --old-passwords, but only when using 4.1 clients. That'll force the server to use the older password authentication mechanism. David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL 4.1 and MyCC
Okay, I've now added this using the 'old-passwords' syntax in my.cnf file. Still doesn't make any difference. Have no idea about how to change passwords from 'old' to 'new' -Original Message- From: Peter Burden [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 5:19 PM To: Paul DuBois Cc: Christensen, Dave; '[EMAIL PROTECTED]' Subject: Re: MySQL 4.1 and MyCC Paul DuBois wrote: At 11:55 -0500 6/11/03, Christensen, Dave wrote: I upgraded my test MySQL server yesterday to 4.1 and I'm now receiving an error when I try to connect using MyCC. The error is ERROR 1249: Client does not support authentification protocol requested by server. Consider upgrading MySQL client. I've tried to find a solution on the website, but either it's not mentioned there or my search skills need some refinement (probably the latter :-) Anyone have any idea what I have to do to solve this one? Start the server with the --old-passwords option. Or put this in an option file: [mysqld] old-passwords Thanks - that also answers an earlier post of mine - although I think it should be old-password and if you've (as I did) set up 4.1 with new style passwords, you can't then just drop this into /etc/my.cnf without also changing all the passwords - the new and old schemes encrypt in a different way AFAIK. That'll force the server to use the older password authentication mechanism. David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk/~jphb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Need Help About mysql.sock ERROR
:-) I think the first issue is to make sure that the server is running. Typically the 'sock' file issue will solve itself if the server is running. -Original Message- From: Ernesto Silva [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 12:38 AM To: [EMAIL PROTECTED] Subject: Re: Need Help About mysql.sock ERROR You have several options, here is, I think, the easiest: First you need to locate the sock file. The location depends on the distribution (in my system is in /tmp). Use find / -name mysql.sock. On some distributions the name can be slightly different, for example mysqld.sock. Then create a symbolic link in '/var/lib/mysql/' pointing mysql.sock Ernesto - Original Message - From: Pratchaya Chatuphian [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 09, 2003 11:50 PM Subject: Need Help About mysql.sock ERROR ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I use MDK 8.2 and MySQL 4.0.13 i found this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone help me to solve this problem ? Thank u for advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 2002: Can't connect to local MySQL server through socke t '/var/lib/mysql/mysql.sock' (2)
Is your server daemon running? -Original Message- From: Pratchaya Chatuphian [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 2:25 AM To: [EMAIL PROTECTED] Subject: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I use MDK 8.2 and MySQL 4.0.13 i found this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone help me to solve this problem ? Thank u for advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ERROR 2002: Can't connect to local MySQL server through socke t '/var/lib/mysql/mysql.sock' (2)
You should be able to find a file in your data directory titled hostname.err. What is the content of that file? If the server is having problems running, you'll more than likely find information in that .err file. -Original Message- From: Christensen, Dave [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 2:31 AM To: 'Pratchaya Chatuphian'; '[EMAIL PROTECTED]' Subject: RE: ERROR 2002: Can't connect to local MySQL server through socke t '/var/lib/mysql/mysql.sock' (2) Is your server daemon running? -Original Message- From: Pratchaya Chatuphian [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 2:25 AM To: [EMAIL PROTECTED] Subject: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I use MDK 8.2 and MySQL 4.0.13 i found this error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Can anyone help me to solve this problem ? Thank u for advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: NEWBIE QUESTION: Copying Databases from local to server
You can see more in-depth descriptions in the documentation, but for a simple shot at migrating data and database structures from one machine to another, you can try: Prompt mysqldump --add-drop-table lots of variety here -uroot -ppassword | mysql --host=new.host.ip.add -uroot -ppassword You can dink around with the GUI's, but the std command line tools will get you there just fine... :-) -Original Message- From: Tim Winters [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 04, 2003 3:09 PM To: [EMAIL PROTECTED] Subject: RE: NEWBIE QUESTION: Copying Databases from local to server Thanks everyone for the replies. I know I should probably be using phpMyadmin or the command line to export my info out of my local mySQL setup but... I'm using mySQL control center. Using this tool I can't seem to export. There is a button to do it but it is always greyed out. Is there a step I'm missing? thx Tim Winters Creative Development Manager Sampling Technologies Incorporated 1600 Bedford Highway, Suite 212 Bedford, Nova Scotia B4A 1E8 www.samplingtechnologies.com [EMAIL PROTECTED] [EMAIL PROTECTED] Office: 902 450 5500 Cell: 902 430 8498 Fax:: 902 484 7115 -Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: June 4, 2003 3:35 PM To: [EMAIL PROTECTED] Subject: Re: NEWBIE QUESTION: Copying Databases from local to server I'd suggest using phpMyAdmin on the remote server for your setup. Depending on the application, it might make further transfers easier in the future. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Creative Solutions New Media [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, 04 June, 2003 00:49 Subject: NEWBIE QUESTION: Copying Databases from local to server Hello, I have several databases currently located on my local machine that I need to copy to a remote server. Con someone explain the process and details of how this is done? Thanks, Tim Winters Manager, Creative Development Sampling Technologies Incorporated (STI) [EMAIL PROTECTED] [EMAIL PROTECTED] W: 902 450 5500 C: 902 430 8498 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql query output get wrapped
Since this in running in Windows, I don't think you will have much luck in a simple console display. While you can change size properties for Window and Screen Buffer, these sizes are ONLY for length and you can't really do much for horizontal size. What I'd suggest tying is to run mysql as a command line batch job with the results being redirected into a .txt file that you could open with an editor that will allow wider lines. Something like: C:\mysql -uuserid -pyourpassword yourcommandtext.sql yourcommandoutput.txt Without using a tool like EMS MySQL Manager, etc, I think this might be your best bet. -Original Message- From: Keith Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 11:14 AM To: 'Asif Iqbal'; Paul DuBois Cc: [EMAIL PROTECTED] Subject: RE: mysql query output get wrapped Asif, If I understand you correctly, you should just be able to increase the size of the DOS window (Of course this would have to be on Windwos). If so simply right click the Title Bar and Choose Properties, then on the Layout Tab increase the Window Size and Screen Buffer size Hope this Helps Kind Regards -Original Message- From: Asif Iqbal [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 4:57 PM To: Paul DuBois Cc: [EMAIL PROTECTED] Subject: Re: mysql query output get wrapped something like this ++-+---++++---+- --+-+ | id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner | Subject | InitialPriority | ++-+---++++---+- --+-+ | 5 | 5 | 4 | ticket | NULL | NULL |16 | RE: phonebook | 10 | ++-+---++++---+- --+-+ *unwrapped* On Tue, 3 Jun 2003, Paul DuBois wrote: At 11:39 -0400 6/3/03, Asif Iqbal wrote: I want the columns unwrapped to make it easy to read. Sorry if I confused you earlier I still don't know what you mean. What would this output *look like*? Please show an example. On Tue, 3 Jun 2003, Paul DuBois wrote: At 11:27 -0400 6/3/03, Asif Iqbal wrote: mysql select * from Tickets limit 1; ++-+---++++---+ ---+-+---+--+--+ +--+-++-+--- +--+-++-+ --+--+---+-+-+-- --+--+---+-+-+ ---+--+ | id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner | Subject | InitialPriority | FinalPriority | Priority | Status | TimeWorked | TimeLeft | Told| Starts | Started | Due | Resolved | LastUpdatedBy | LastUpdated | Creator | Created | Disabled | ++-+---++++---+ ---+-+---+--+--+ +--+-++-+--- +--+-++-+ --+--+---+-+-+-- --+--+---+-+-+ ---+--+ | 5 | 5 | 4 | ticket | NULL | NULL | 16 | RE: phonebook | 10 |80 | 10 | resolved | 0 | NULL | 1970-01-01 00:00:00 | NULL | NULL| 1970-01-01 00:00:00 | NULL | 1 | 2001-04-17 18:38:02 | 1 | 2001-04-17 18:26:46 |0 | ++-+---++++---+ ---+-+---+--+--+ +--+-++-+--- +--+-++-+ --+--+---+-+-+-- --+--+---+-+-+ ---+--+ 1 row in set (0.00 sec) Is there a way I can get the output unwrapped something like this mysql select * from Tickets limit 1 \G *** 1. row *** id: 5 EffectiveId: 5 Queue: 4 Type: ticket IssueStatement: NULL Resolution: NULL Owner: 16 Subject: RE: phonebook InitialPriority: 10 FinalPriority: 80 Priority: 10 Status: resolved TimeWorked: 0 TimeLeft: NULL Told: 1970-01-01 00:00:00
RE: database copy
If you check the documentation about mysqldump, you'll find the command line syntax for using a combination of mysqldump on the source machine and mysql pumping to the target machine. It's simple, fast and everything is there to work just fine. -Original Message- From: Paul Najman [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 11:33 AM To: Fabio Bernardo Cc: [EMAIL PROTECTED] Subject: Re: database copy Fabio, I have had to do this quite a few times myself. If you have use of a server with MySQL on it then it can be done using a GUI (I use MySQL-Front, but most people seem to MySQL Control Center. All you do is use the built-in tools to transfer table structures + data to a database (any) on the external server and then transfer it from there to the other PC. If this doesn't make much sense to you, let me know! Best wishes, Paul Najman - Original Message - From: Fabio Bernardo [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 4:12 PM Subject: database copy Hi there, I ´m using the Mysql control center with a database called dbONE in a PC, and I would like to copy it to another PC, Do you have any idea to how can I do it? I dont wanna create all the tables again... Thanks a lot -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Red Hat linux database to Mac OS X
Not that particular move, but have used mysqldump/mysql combo to move between linux--windows and back. Works well. -Original Message- From: Greg Grasmehr [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 1:19 PM To: [EMAIL PROTECTED] Subject: Red Hat linux database to Mac OS X Hello, I was wondering if anyone has experienced moving a MySQL database from Linux/Intel X86 to Mac OS X? I plan to use mysqldump of course. I was only wondering if anyone has run into problems they might share. Thanks. Greg __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to fill an Blob with binary data
What is the source of the binary data you want to use to fill the blob? -Original Message- From: Mike Hillyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:23 PM To: Adam Clauss; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Like I said, for Image and text blobs, use MyCC and it should work. Mike Hillyer www.vbmysql.com -Original Message- From: Adam Clauss [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 11:18 AM To: [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data I am in need of help with the same question (sent late last night, but apparently got passed over). Adam Clauss [EMAIL PROTECTED] -Original Message- From: Thomas Hoelsken [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 12:11 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: How to fill an Blob with binary data Hi, isn't there any other solution instead of using PHP just for filling an Blob!? I don't need php and would prefer any other way! Thanks, Thomas -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 6:56 PM To: [EMAIL PROTECTED] Subject: Re: How to fill an Blob with binary data Search the mailing list archives for this... There is a link to this article: http://www.php4.com/forums/viewtopic.php?t=6 I wonder if the mailinglist search was powered by google more people would use it? On Tue, 27 May 2003, Thomas Hoelsken wrote: Hi, I would like to fill an Blob with binary data thru SQL-statements or any other MySQL tools and don't know how!? Are there suggestions? Thanks, Thomas Hoelsken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Query formulation question
Here's a link to an article that discusses how to set up cross-tab queries. http://www.devshed.com/Server_Side/MySQL/MySQLWiz/page1.html -Original Message- From: Michael Shulman [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 12:08 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Query formulation question This is quite complicated with SQL. However, Microsoft Excel has excellent tools for creating crosstabs exactly like this. -ms -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2003 9:56 AM To: [EMAIL PROTECTED] Subject: Query formulation question Hi there, I have some experience with SQL, but I'm drawing a blank on this one. I have a table with these fields: Location Unit StartDate StopDate I want to construct a SELECT statement to get to a report that looks something like this: Location1Location2 Location3 ... Date1 count of units where Datex is between Date2 StartDate and StopDate ... Date3 ... Where Date1, Date2, etc are a week apart within a given date range. Any help appreciated. -Bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Suggestions for choosing GUI Language that has a MySQL DB bac kend
:-) My offering would be to suggest developing in Delphi or Kylix, depending on the platform. David Christensen Brokers International, Ltd. 1200 E Main St Panora, IA 50216 (641) 755-2775 [EMAIL PROTECTED] -Original Message- From: Martin Gainty [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 10:55 AM To: [EMAIL PROTECTED] Cc: MySQL List Subject: Re: Suggestions for choosing GUI Language that has a MySQL DB backend If speed isnt a issue I would say develop with one of the interpreted languages (Perl/Python) My experience trying to get anything compiled under linux or windows because of missing headers or libraries will cause you and your project to experience insufferable delay. Regards, Martin - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 03, 2003 9:24 AM Subject: Suggestions for choosing GUI Language that has a MySQL DB backend Hi MySQL Listers, I'm wondering if someone might provide some guidance about what programming language might best accomplish the following. I have been asked to write an interactive GUI program that allows for the display of results from related queries. For example, launching the application wil generate the first query, which will return a list of names of individuals. Selecting a name triggers another query that returns demographic information about that person and a list of their interests. Selecting an interest from the list triggers another query that returns a list of venues such as museums or restaurants where the person can explore that interest. And selecting the venue triggers a query that returns information such as driving directions or food menu. I have the MySQL database designed and tested, and the queries work as intended. Also, the load on mysqld will be limited, so performance is not a major issue. Unfortunately, my employer does not want a web-based solution, so PHP is out. And all the activity has to occur in various sections of a single screen. My apologies if I'm posting to the wrong list. But if someone has accomplished something similar to the above using a MySQL backend, I would appreciate any advice or direction that might be provided. Thank you for reading this post. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyCC
I've noticed something with MySQL Control Center. Today I wanted to browse an entire table, which has roughly 35,000 rows. I unchecked the limit to 1000 box in the General Options and double-clicked on the table. Once MyCC started to display the table, my free memory dropped to 4 MB and performance of the PC dropped dramatically. I then terminated MyCC. Even after MyCC disappeared from the task list in Task Manager, memory continued to show only 4 MB available. I then ran MemTurbo which defragmented RAM and my available memory jumped back up to 800+ MB available. Does MyCC have a known memory problem/issue? David Christensen Brokers International, Ltd. 1200 E Main St Panora IA 50216 Phone: (641) 755-2775 Fax: (641) 755-2381 Email: [EMAIL PROTECTED]
RE: 4.0.12 RPM's
Lenz, Of the packages listed, the only one of concern to me was the ODBC package. Since this is a fresh RH 8.0 install, I was also going to upgrade the MySQL ODBC driver. By using the command line syntax from your previous message ($ rpm -qRp MySQL-server-4.0.12-0.i386.rpm), I was able to install all of the RPM's that I downloaded from MySQL without any warnings. I also downloaded and installed the latest ODBC drivers and have been running all weekend. Thanks for your time and trouble! :-) Dave -Original Message- From: Lenz Grimmer [mailto:[EMAIL PROTECTED] Sent: Sunday, March 23, 2003 5:36 AM To: Christensen, Dave Cc: 'mysql users' Subject: RE: 4.0.12 RPM's -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Fri, 21 Mar 2003, Christensen, Dave wrote: I downloaded the RPM's from the Chicago mirror site and saved the files in a directory /data/downloads/mysql. I then maneuvered there using the GUI file manager and double-clicked on the file names. That caused a GUI to open up and it displayed status as it checked things out. When it displayed Computing package dependencies, another dialog window opened up displaying a heading of Packages Not Found with additional text The following packages could not be found on your system. Installation cannot continue until they are installed. Below that message was a table with two columns, which had headings and data as follows: Unlocatable package Required by libmysqlclient.so.10libdbi-dbd-mysql libmysqlclient.so.10mod_auth_mysql libmysqlclient.so.10MyODBC libmysqlclient.so.10MySQL-Python libmysqlclient.so.10perl-DBD-MySQL libmysqlclient.so.10qt-MySQL libmysqlclient.so.10php-mysql These messages are still displayed on my screen. OK, now I see you problem. The packages listed on the right have been linked against an older version of MySQL. If you try to upgrade to the latest version of MySQL (which includes a newer version of the libmysqlclient library), it would also replace the package that includes the library needed for these packages. As a workaround, you could try to omit the MySQL-shared package (it's not required for the client and server package anyway). This should leave the old MySQL client library installed on your system, thus resolving the above dependency problem. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE+fZwISVDhKrJykfIRAgAwAJkBZkMZArGxMUG6JV2haqfwnMIvGwCeMJpv ctNFUCAANBeFl0vpUCbNVcg= =a59l -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
4.0.12 RPM's
Good Morning! I'm trying to install the MySQL RPM's on a newly set up RH 8.0 box. Things seem to go well until I try to install the server RPM, which fails stating that it can't find libmysqlclient.so.10 on the computer. What do I have to do to get around this problem? Thanks! David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: 4.0.12 RPM's
I downloaded the RPM's from the Chicago mirror site and saved the files in a directory /data/downloads/mysql. I then maneuvered there using the GUI file manager and double-clicked on the file names. That caused a GUI to open up and it displayed status as it checked things out. When it displayed Computing package dependencies, another dialog window opened up displaying a heading of Packages Not Found with additional text The following packages could not be found on your system. Installation cannot continue until they are installed. Below that message was a table with two columns, which had headings and data as follows: Unlocatable package Required by libmysqlclient.so.10libdbi-dbd-mysql libmysqlclient.so.10mod_auth_mysql libmysqlclient.so.10MyODBC libmysqlclient.so.10MySQL-Python libmysqlclient.so.10perl-DBD-MySQL libmysqlclient.so.10qt-MySQL libmysqlclient.so.10php-mysql These messages are still displayed on my screen. Thanks Dave David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] -Original Message- From: Lenz Grimmer [mailto:[EMAIL PROTECTED] Sent: Friday, March 21, 2003 11:56 AM To: Christensen, Dave Cc: 'mysql users' Subject: Re: 4.0.12 RPM's -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 21 Mar 2003, Christensen, Dave wrote: I'm trying to install the MySQL RPM's on a newly set up RH 8.0 box. Things seem to go well until I try to install the server RPM, which fails stating that it can't find libmysqlclient.so.10 on the computer. What do I have to do to get around this problem? Hmm, I cannot reproduce this: $ rpm -qRp MySQL-server-4.0.12-0.i386.rpm fileutils sh-utils /bin/sh /bin/sh /usr/bin/perl Our MySQL server package does not have that dependency. Would you mind posting the exact error message you get, including the exact command you used? Thanks! LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE+e1IfSVDhKrJykfIRAvJtAJ9ZUTvOJZhAa3jRbvB5WUa7Cd/4PwCeICpL 68ycNBgJiYUjFeKVxWUjW0w= =MA0C -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Licence Free Import/Export for Access?
Since DBScripter uses ODBC, you'll have to set up a Data Source in the ODBC manager in Windows for any database you wish to access with the product. For that you'll need an Access driver, but you can download that driver from MS at no cost. It would be nice if DBScripter would be ported to LINUX and other UNIX flavors.. :-) -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 6:53 AM To: mysql users Cc: Arthur Fuller Subject: Re: Licence Free Import/Export for Access? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Arthur, et al -- ...and then Arthur Fuller said... % % I have used dbScripter a lot for this kind of work. It is definitely NOT % necessary to own Access to use it. Cool! That's what I wanted to pin down. So if someone sends me an Access .MDB file I can just open it up and get the data out, right? ... % and using that I have frequently moved databases from SQL 2000, Oracle and % Access to MySQL. dbScripter will work fine with virtually any ODBC-compliant % back end. Since I don't know much about ODBC, here's another place where I have a question... Does the ODBC back end read the Access DB file, and if so what sorts of back ends are out there for Linux and FreeBSD? % Hth, % Arthur Thanks a *bunch* HAND :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+S5UiGb7uCXufRwARArMHAKCboab1FElihe3Hrepf1ZRrVW4ZsACeI5do odawCIN/W+BFMEOV6V028uQ= =JLk/ -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Licence Free Import/Export for Access?
There's a relatively low-cost ODBC utility called DBScripter that does a pretty good job creating scripts for exporting ddl and data from ODBC datasources. It allows you to build dialects for server-based SQL variations. I don't think that there's a current MySQL dialect, but looks pretty simple to put one together. Here's the link to the site: http://www.dkgadvancedsolutions.com/dbscript.htm -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 10:43 AM To: mysql users Cc: Neil Williams Subject: Re: Licence Free Import/Export for Access? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Neil -- ...and then Neil Williams said... % % Hi Hi! % % Is there a licence free way to Import (and Export) Access databases (mdb % files) into (out from) mySQL? I haven't seen one yet. It's quite possible that nobody has written a file converter -- also quite possibly because MS hasn't released the file spec and nobody has reverse-engineered it :-) I did a quick CPAN search and found DBIx::Record::Format::ODBC::MSAccess which looks somewhat hopeful; you might dig into that a bit. HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+SnmlGb7uCXufRwARAk5tAJ9AFHohak4IXrL9jhY3suxhWfExvgCgnZvv X7/gEKohVSZhdAu7N+bTLxo= =oJMt -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Licence Free Import/Export for Access?
Yes, I think you misunderstood. You don't have to own MS Access or have it on your PC to use DBScripter. You DO have to set up an ODBC data source that points to the Access database though. That process can be accomplished without owning Access. -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 12, 2003 9:45 PM To: mysql users Cc: j.urban; Christensen, Dave Subject: Re: Licence Free Import/Export for Access? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dave J, et al -- [re DBScripter and urSQL] Those are nice tools, but if I read you correctly they only work if one has MS Access. The original poster, if I read *him* correctly, wants a way to read Access DB files and turn them into MySQL files -- but without having to have MS Access. That would be my desire if I ever had to touch an MS Access file, since I don't have Access almost don't run Windows at all. Did I misunderstand anyone? HTH TIA HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+SxTLGb7uCXufRwARAhvNAKCDaezt+gSN4BQinKadUoWzvw2wWACg5hrn apGMD7+rA8vIqlbp2ZkBS4Y= =N2rx -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Still Cannot Get MySQL To Run
The problem you are having is a result of the permissions that are set on the data and log directories that are identified in my.cnf, and is documented in the MySQL Reference Manual. If you change the ownership of the data and log directories to mysql (both user and group), the error should go away. David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] -Original Message- From: CM Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 10:56 PM To: [EMAIL PROTECTED] Subject: Still Cannot Get MySQL To Run Have a new years resolution, to get MySQL to run Here are the errors that I keep getting... I don't understand what this is telling me? from /var/log 021214 19:13:21 mysqld started 021214 19:13:21 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (er rno: 13) 021214 19:13:21 mysqld ended I haven't messed around with this since late Nov., but I really don't want to give up on this. Any ideas? So, it was recommended to try this-run 'install_db' from the scripts directory So I tried that and here is my output: Installing all prepared tables 030107 22:35:39 /usr/local/libexec/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/local/bin/mysqladmin -u root password 'new-password' /usr/local/bin/mysqladmin -u root -h phoenix.miller.org password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd /usr/local ; /usr/local/bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /usr/local/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com what in the hell am I doing wrong here, this should not be that hard to set up and run? = People without goals get used by those who have goals - Unknown * GAIM ID: cmmiller1973 * __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query mysql on another server
I can see where it would be nice to be able to do that. -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 4:06 PM To: Christensen, Dave; 'Chris Boget'; [EMAIL PROTECTED]; Paul DuBois Subject: Re: Query mysql on another server Paul, Dave, If I understood the initial question correctly, your first suggestion is not what he wants. I think he's talking about accessing two servers from the same connection, which is not possible: [snip] You can't write a SQL statement that refers to tables hosted by another server. (I've seen claims that this can be done, but they always turn out to have been made by people who haven't actually tried it.) It's possible with M$ SQL Server. I guess that's the background for this question. I've recently performed a training course for an organisation where they want to migrate from SQL Server to MySQL, and they miss this feature quite a bit. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Christensen, Dave [EMAIL PROTECTED]; 'Chris Boget' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003 7:35 PM Subject: RE: Query mysql on another server At 12:28 -0600 1/7/03, Christensen, Dave wrote: You can use the command line mysql with the host option, i.e. --host=hostname, to connect to another machine. Likewise, you could set up a data source using ODBC to look at the database on the second host machine through which you could generate queries against the tables on the other host's database tables. If I understood the initial question correctly, your first suggestion is not what he wants. I think he's talking about accessing two servers from the same connection, which is not possible: Throughout this chapter, I've been making the implicit assumption that all the tables involved in a multiple-table operation are managed by a single MySQL server. If this assumption is invalid, the tables become more difficult to work with. A connection to a MySQL server is specific to that server. You can't write a SQL statement that refers to tables hosted by another server. (I've seen claims that this can be done, but they always turn out to have been made by people who haven't actually tried it.) -- MySQL Cookbook, p671 -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 11:12 AM To: Chris Boget; [EMAIL PROTECTED] Subject: Re: Query mysql on another server At 10:08 -0600 1/7/03, Chris Boget wrote: We have a *nix network and on that network we have 2 web servers. One for development (server1) and one for production (server2). And on each of those servers we have MySQL installed. Is there a way we can query a table on server2 from server1? No. I know that when you are using a database from the mysql command line, you can query a table in another database just by using select databasename.tablename. But the same method using servername doesn't work. Is this even possible? No. thnx, Chris sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query mysql on another server
You can use the command line mysql with the host option, i.e. --host=hostname, to connect to another machine. Likewise, you could set up a data source using ODBC to look at the database on the second host machine through which you could generate queries against the tables on the other host's database tables. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 11:12 AM To: Chris Boget; [EMAIL PROTECTED] Subject: Re: Query mysql on another server At 10:08 -0600 1/7/03, Chris Boget wrote: We have a *nix network and on that network we have 2 web servers. One for development (server1) and one for production (server2). And on each of those servers we have MySQL installed. Is there a way we can query a table on server2 from server1? No. I know that when you are using a database from the mysql command line, you can query a table in another database just by using select databasename.tablename. But the same method using servername doesn't work. Is this even possible? No. thnx, Chris sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Re: PHP and MySQL bug
Then go to c:\winnt\system32\drivers\etc and make the changes in the hosts file that you will find there. -Original Message- From: Nuno Lopes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 1:25 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] Re: PHP and MySQL bug I'm using Windows 2000. - Original Message - From: Cleber [EMAIL PROTECTED] To: Nuno Lopes [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003 10:23 AM Subject: Re: [PHP] Re: PHP and MySQL bug Try add to /etc/hosts the name and ip of DB is located - Original Message - From: Nuno Lopes [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003 7:31 AM Subject: Re: [PHP] Re: PHP and MySQL bug I have the latest version of PHP (4.3.0) as module in apache 2.0.43 and mysql 3.23.49. Everything is working fine, except this. With pconnect the error is the same! - Original Message - From: Larry Brown [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Monday, January 06, 2003 6:28 PM Subject: RE: [PHP] Re: PHP and MySQL bug This definitely sounds like a buggy installation or there may be some problem with the communication between the web server and the mysqld. Is the db on a different machine? Try using mysql_pconnect instead of connect just to see what result you get. I have read some unfavorable statements about using pconnect with a large number of hits so if it works you should read the comments about it on php.net. Do a search for mysql_pconnect. Larry S. Brown Dimension Networks, Inc. (727) 723-8388 -Original Message- From: Nuno Lopes [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 1:09 PM To: MySQL List; [EMAIL PROTECTED] Subject: [PHP] Re: PHP and MySQL bug The problem is if I close the connection and reopen it the query is done, but if I remain with the same connection has the previous query, mysql returns an error. - Original Message - From: Larry Brown [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sunday, January 05, 2003 4:16 PM Subject: Re:PHP and MySQL bug Try replacing the following line... @MYSQL_QUERY(UPDATE d SET h='$h' WHERE id='$id'); // this query doesn't work With... $query = UPDATE d SET h='$h' WERE id='$id'; $queryr = mysql_query($query) or die(The sql statement does not execute); if(mysql_affected_rows() !== 1) { die(The sql statement is successfully run however either h did not change or there is an internal error. Try executing the sql from the command line to make sure it otherwise works.); } and see which is coming back. Larry S. Brown Dimension Networks, Inc. (727) 723-8388 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: host.frm
Again, this specific problem is mentioned in the reference guide. From that and my experiences, we're looking at a permissions issue. Hannes needs to look at the permissions on his data and logging directories to make sure that they are set to the default mysql:mysql. -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 10:45 AM To: Jason Steig; MySQL Mailinglist Subject: Re: host.frm On 1/1/03 8:43 PM, Jason Steig [EMAIL PROTECTED] wrote: ./myqld: Can't find file : './mysql/host.frm' (errno:13) does anyone know how to solve this problem? This file is part of the host table in your mysql database 'mysql'. Did you by any chance copy the mysql data directory or parts of it or do any actions that would change permissions or even delete file in this directory (possibly /usr/local/mysql-version/data) ? In the worst case you need to back up your data directory and have to run the install_db script again after you have set the root password to '' (nothing). HTH/h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Select Date Help
I think you could also use: WHERE YEAR(date) = 2003 AND MONTH(date) = 01 -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 5:09 PM To: [EMAIL PROTECTED] Cc: Max Clark Subject: Re: Select Date Help On 2 Jan 2003, at 14:27, Max Clark wrote: I have a DATE column (CCYY-MM-DD), I would like to do a query like this: select * from table where date = '2003-01' What additional information do I need to provide for this query to work properly? You need to explain to us what result you expect. Since '2003-01' is not a complete date, your criterion will never be met. Maybe you want something like this? SELECT * FROM table_name WHERE date BETWEEN '2003-01-01' AND '2003-01-31'; -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: HELP for mysql ended error
If you check the MySQL reference guide, you'll see that the Errorcode 13 is indicating that you don't have your permissions set up correctly for your data and log directories. Once you fix that, you should (hopefully) be okay. David Christensen Brokers International, Ltd. 1200 E Main St PO Box 160 Panora, IA 50216 (800) 362-1097 or (641) 755-2775 [EMAIL PROTECTED] -Original Message- From: Chamlee, Douglas, B. (Contractor) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 11:38 AM To: '[EMAIL PROTECTED]' Subject: HELP for mysql ended error I am trying to upgrade the mysql database. I am installing on a Unix (SGI's IRIX) platform, upgrading to 3.23.52. I am installing a tar distribution (binary) from SGI's freeware web site. The installation goes fine - no errors - execpt when I try to start mysql it returns mysql ended and will not start. If there are any mysql pro's out there that could help I would really, really, really appreciate it. Thanks When I try to start mysql I get the following error at the command line: [62]my_server_name:/usr/freeware/binsafe_mysqld Starting mysqld daemon with databases from /local/mysql 021231 10:06:19 mysqld ended This is the output from my .err file from mysql: [84]server1.bliss.army.mil :/local/mysqlmore server1.bliss.army.mil.err 021231 09:51:09 mysqld started /usr/freeware/sbin/mysqld: File './server1-bin.014' not found (Errcode: 13) 021231 9:51:09 Could not use server1-bin for logging (error 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Can't create/write to file '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Normal shutdown 021231 9:51:09 /usr/freeware/sbin/mysqld: Error on delete of '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 2) 021231 09:51:09 mysqld ended 021231 09:51:50 mysqld started /usr/freeware/sbin/mysqld: File './server1-bin.014' not found (Errcode: 13) 021231 9:51:50 Could not use doe1-bin for logging (error 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Can't create/write to file '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Normal shutdown 021231 9:51:50 /usr/freeware/sbin/mysqld: Error on delete of '/local/mysql/doe1.bliss.army.mil.pid' (Errcode: 2) 021231 9:51:50 /usr/freeware/sbin/mysqld021231 09:51:50 mysqld ended 021231 09:57:06 mysqld started /usr/freeware/sbin/mysqld: Too many parameters /usr/freeware/sbin/mysqld Ver 3.23.52 for sgi-irix6.5 on mips Use '--help' or '--no-defaults --help' for a list of available options 021231 09:57:06 mysqld ended 021231 10:05:01 mysqld started /usr/freeware/sbin/mysqld: Fatal error: Can't find messagefile '/usr/freeware/bin/share/mysql/english/errmsg.sys' 021231 10:05:02 mysqld ended 021231 10:05:24 mysqld started /usr/freeware/sbin/mysqld: Fatal error: Can't find messagefile '/usr/freeware/bin/share/mysql/english/errmsg.sys' 021231 10:05:24 mysqld ended [85]server1.bliss.army.mil :/local/mysql!! more server1.bliss.army.mil.err 021231 09:51:09 mysqld started /usr/freeware/sbin/mysqld: File './server1-bin.014' not found (Errcode: 13) 021231 9:51:09 Could not use sever1-bin for logging (error 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Can't create/write to file '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021231 9:51:09 /usr/freeware/sbin/mysqld: Normal shutdown 021231 9:51:09 /usr/freeware/sbin/mysqld: Error on delete of '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 2) 021231 09:51:09 mysqld ended 021231 09:51:50 mysqld started /usr/freeware/sbin/mysqld: File './server1-bin.014' not found (Errcode: 13) 021231 9:51:50 Could not use server1-bin for logging (error 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Can't create/write to file '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021231 9:51:50 /usr/freeware/sbin/mysqld: Normal shutdown 021231 9:51:50 /usr/freeware/sbin/mysqld: Error on delete of '/local/mysql/server1.bliss.army.mil.pid' (Errcode: 2) 021231 9:51:50 /usr/freeware/sbin/mysqld021231 09:51:50 mysqld ended 021231 09:57:06 mysqld started /usr/freeware/sbin/mysqld: Too many parameters /usr/freeware/sbin/mysqld Ver 3.23.52 for sgi-irix6.5 on mips Use '--help' or '--no-defaults --help' for a list of available options 021231 09:57:06 mysqld ended 021231 10:05:01 mysqld started /usr/freeware/sbin/mysqld: Fatal error: Can't find messagefile '/usr/freeware/bin/share/mysql/english/errmsg.sys' 021231 10:05:02 mysqld ended 021231 10:05:24 mysqld started /usr/freeware/sbin/mysqld: Fatal error: Can't find messagefile
RE: Problems / Reset password / switching to decafe
Rick, What messages are you seeing in the .err file in your logging directory? I typically run my servers with the KDE up and I use the service configuration tool to restart services. Have you tried to fire up MySQLCC and connect to your server? Dave -Original Message- From: Richard Nagle [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 12:45 PM To: [EMAIL PROTECTED] Subject: Problems / Reset password / switching to decafe I been trying to follow the instruction at mysql site to fix mysql, and get it back up and running, so i can add databases. the problem is getting into it (mysql), for some reason the mysqladmin password does not work. so, been forced to kill -9 pid and try the mysql instruction to rest password no luck here is a copy and paste of my terminal window: Trying to start up mysqld; [MacG4a:~] rnagle% mysqld --skip-grant-tables 021231 13:38:05 Can't start server : Bind on unix socket: Address already in use 021231 13:38:05 Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 021231 13:38:05 Aborting 021231 13:38:05 mysqld: Shutdown Complete [MacG4a:~] rnagle% Trying another thing; [MacG4a:~] rnagle% mysqladmin -u root password 4321 mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! [MacG4a:~] rnagle% Anyone care to comment on what going on here? I already kill the process, and was trying to restart How does one get back into flushing the passwords, and gaining access, since the instruction don't work. What am I doing wrong, or? what step are missing? or what brand of coffee should I switch to. Big Thanks Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php