Re: DB recovery
Thanks, That was pretty easy... And, thank you mysql! ;-) Yves On Fri, 28 Jan 2005 08:14:37 -0600, Tom Crimmins <[EMAIL PROTECTED]> wrote: > [snip] > > This box recently crashed as a result of a power outage (possible surge, my > surge protector may have failed) > The box doesn't boot up, but the HD is ok... all my docs are there.. > So, I'm wondering if it's somehow possible to get the MySQL 3 files and > recreate them on another box we have here that runs MySQL 4.0. > Is this possible? > It wouldn't be as simple as getting the files from the dead box and putting > them in the new box, would it? > > > [/snip] > > If these were myisam tables, assuming the files didn't get badly damaged, > you should be able to copy the directory for each database you need to > recover into the mysql datadir on the new host. You may have to use > myisamchk to repair the indexes. > > http://dev.mysql.com/doc/mysql/en/myisamchk-syntax.html > > You will want to do all of this with mysqld stopped. > > --- > Tom Crimmins > Interface Specialist > Pottawattamie County, Iowa > -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DB recovery
Hello, I have a server here that ran MySQL 3.23.x This box recently crashed as a result of a power outage (possible surge, my surge protector may have failed) The box doesn't boot up, but the HD is ok... all my docs are there.. So, I'm wondering if it's somehow possible to get the MySQL 3 files and recreate them on another box we have here that runs MySQL 4.0. Is this possible? It wouldn't be as simple as getting the files from the dead box and putting them in the new box, would it? Thanks, -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data conversion question
Thanks Konrad, Yves On Thu, 23 Dec 2004 23:28:31 +0100, Konrad Kieling <[EMAIL PROTECTED]> wrote: > > Does MySQL have commands that would allow me to convert Base64 data to > > Binary and then convert that Binary to a string format? > have a look at the attached file (hope the attachment did not get > stripped). it contains some udf-functions for base64 en/de-coding. a > little description is included. > > ciao, > konrad > > > -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Data conversion question
Hello, I was looking throught the manual a bit, I haven't found the answer I'm looking for... Does MySQL have commands that would allow me to convert Base64 data to Binary and then convert that Binary to a string format? Thanks, -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL and partitions
Thanks to all of you who replied. Yves On Wed, 3 Nov 2004 13:57:33 + (GMT), andy thomas <[EMAIL PROTECTED]> wrote: > On Wed, 3 Nov 2004, Yves Arsenault wrote: > > > Thanks for the reply, > > > > Is there any information on the mysql.com website on how to store data > > on 2 separate partitions? > > I'm not sure but you can use symbolic links to make databases in different > partitions appear to be under the one that mysql uses. For example, > suppose that on your system, the database DB_A is under /usr and database > DB_B is uder /var - mysql can see /usr/DB_A but not /var/DB_B. But if you > symbilically link /var/DB_B to /usr/DB_B with: > > ln -s /var/DB_B /usr/DB_B > > then mysql can see and use DB_B. Of course, you also need to be sure mysql > has permissions to read and write to DB_B in /var. > > Hope this helps, > > Andy > > > > > On Wed, 3 Nov 2004 13:21:59 + (GMT), andy thomas <[EMAIL PROTECTED]> wrote: > > > On Wed, 3 Nov 2004, Yves Arsenault wrote: > > > > > > > Hello all, > > > > > > > > I have MySQL installed on a Mandrake Linux system, it is installed on > > > > the /usr partition. > > > > > > > > I was wondering, is it possible to store some databases on the /var > > > > partition while MySQL is installed on the /usr partition? > > > > > > Yes. In fact, somewhere under the /var tree is the usual place for mysql > > > databases to reside in many installations. > > > > > > > And, if it is possible, can you store DB_A on /usr and DB_B on /var > > > > (or at least 2 different partitions). > > > > > > You can although current thinking in the UNIX/Linux world is that the > > > /usr filesystem should be read-only, which means files & directories that > > > change all the time shouldn't be under /usr. But older UNIXes and Linuxes > > > commonly use /usr/var, /usr/tmp and /usr/var/tmp for holding changing data > > > so it's really up to you. If the databases are big and/or heavily used, I > > > tend to put them on their own /mysql partition or even on their own fast > > > disk. /home/mysql or /export/home/mysql is another possibility. > > > > > > Andy > > > > > > > > > > > > -- > > Yves Arsenault > > > > -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fwd: MySQL and partitions
Ah, Thank you all so much. :-) My purpose for asking was some concerne with the possibility of growing DB sizes.. Question answered. Score one for the list. Yves On Wed, 3 Nov 2004 14:52:35 +0100 (CET), Thomas Spahni <[EMAIL PROTECTED]> wrote: > On Wed, 3 Nov 2004, Yves Arsenault wrote: > > > Thanks for the reply, > > > > Is there any information on the mysql.com website on how to store data > > on 2 separate partitions? > > There is something in the manual. The title is 'Symbolic links to > databases'. > > > > Using Symbolic Links > > > You can move tables and databases from the database directory to other > locations and replace them with symbolic links to the new locations. > You might want to do this, for example, to move a database to a file > system with more free space or increase the speed of your system by > spreading your tables to different disk. > > The recommended way to do this is to just symlink databases to a > different disk. Symlink tables only as a last resort. > > > > Thomas Spahni > > -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: MySQL and partitions
Thanks for the reply, Is there any information on the mysql.com website on how to store data on 2 separate partitions? I'll be doing a bit of research on this soon... Thanks again, Yves On Wed, 3 Nov 2004 13:21:59 + (GMT), andy thomas <[EMAIL PROTECTED]> wrote: > On Wed, 3 Nov 2004, Yves Arsenault wrote: > > > Hello all, > > > > I have MySQL installed on a Mandrake Linux system, it is installed on > > the /usr partition. > > > > I was wondering, is it possible to store some databases on the /var > > partition while MySQL is installed on the /usr partition? > > Yes. In fact, somewhere under the /var tree is the usual place for mysql > databases to reside in many installations. > > > And, if it is possible, can you store DB_A on /usr and DB_B on /var > > (or at least 2 different partitions). > > You can although current thinking in the UNIX/Linux world is that the > /usr filesystem should be read-only, which means files & directories that > change all the time shouldn't be under /usr. But older UNIXes and Linuxes > commonly use /usr/var, /usr/tmp and /usr/var/tmp for holding changing data > so it's really up to you. If the databases are big and/or heavily used, I > tend to put them on their own /mysql partition or even on their own fast > disk. /home/mysql or /export/home/mysql is another possibility. > > Andy > > -- Yves Arsenault -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL and partitions
Hello all, I have MySQL installed on a Mandrake Linux system, it is installed on the /usr partition. I was wondering, is it possible to store some databases on the /var partition while MySQL is installed on the /usr partition? And, if it is possible, can you store DB_A on /usr and DB_B on /var (or at least 2 different partitions). Thanks, -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Tables and performance
Thanks for the reply. Yves On Tue, 19 Oct 2004 14:22:01 +0300, Egor Egorov <[EMAIL PROTECTED]> wrote: > Yves Arsenault <[EMAIL PROTECTED]> wrote: > > > Does a very large number of tables in a database affect MySQL's performance? > > Strictly saying, yes. But the difference won't really matter. So read - no, it > won't affect performance. > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ><___/ www.mysql.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Tables and performance
Hello, I have 2 questions. Is there a maximum number of tables that can be created in a database? Does a very large number of tables in a database affect MySQL's performance? Thanks, -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Windows VS Linux Platform
Hello, I have a very short question I was wondering if there are any differences in how MySQL behaves on Windows and Linux. (i.e. difference in performance, slightly different syntaxetc) If anyone has a link to such documentation it would be greatly appreaciated. Thanks, -- Yves Arsenault -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Function in Where clause
Thanks to all those who answered Even after changing the the day() to dayofmonth(), the queries would still not pull out the request information... After a little reflection, I noticed that something had changed this DB was originally an Access DB, and it was converted to MySQL, in the conversion, the format of that field wasn't quite as before. After I noticed that, a couple of changes, no prob. Thanks again, Yves At 10:52 2004-01-21, you wrote: Yves Arsenault wrote: SELECT * FROM events WHERE day(theDate) = '#dayVal#' and month(theDate) = '#session.month#' and year(theDate) = '#session.year#' Can the day() function be used in this way in the WHERE statement? Yes, but only from version 4.1.1 Use DayOfMonth() or preferably Extract() (which is the method from the SQL standard) per the manual. Is there a better way to achieve this? Loose the single quotes and start using cfqueryparam. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Function in Where clause
Thanks for your response, I'm using ColdFusion along side of MySQL to server dynamic content to some websites. When I run the page that this code is in, I get an SQL syntax error: Syntax error or access violation: You have an error in your SQL syntax near '(theDate) = '31' and month(theDate) = '9' and year(theDate) = '2003'' The right values are displayed from ColdFusion server, but I keep getting the syntax error. Yves At 10:35 2004-01-21, you wrote: function can b used, but value parameter seems syntactically wrong, check that. '#session.month#' to '$month' which is the language,u r using anyway? - Original Message - From: "Yves Arsenault" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 21, 2004 6:37 PM Subject: Function in Where clause > Hello, > > I have a client using a already made calendar component on my server... > > The problem seems to be the SQL code. > > This code works (i believe) with an MS Access or MS SQL server DB... > MySQL version is 3.23.58 > > The code is: > > SELECT * > FROM events > WHERE day(theDate) = '#dayVal#' and month(theDate) = '#session.month#' and > year(theDate) = '#session.year#' > > Can the day() function be used in this way in the WHERE statement? > > Is there a better way to achieve this? > > Thanks, > > Yves > > > -- > 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]
Function in Where clause
Hello, I have a client using a already made calendar component on my server... The problem seems to be the SQL code. This code works (i believe) with an MS Access or MS SQL server DB... MySQL version is 3.23.58 The code is: SELECT * FROM events WHERE day(theDate) = '#dayVal#' and month(theDate) = '#session.month#' and year(theDate) = '#session.year#' Can the day() function be used in this way in the WHERE statement? Is there a better way to achieve this? Thanks, Yves -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Loosing "é" characters in DB insertion
The only language I installed on this box is English... would that be why? Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 14:16 To: 'Yves Arsenault'; Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB insertion The Red Hat client does not display the 233 the same as the MS client. The underlying data should be the same. Try to dump the decimal values of the data in question and see if 233 is present where it is supposed to be. -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 11:44 AM To: Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB insertion Red Hat 9. Looking at the data through Webmin, it appears as though the text is correct in the DB in certain fields, in some others, there are strange characters... I think the clients db may have had slight errors... In any effect, the web interface that is run off this DB doesn't display the 'é' characters.. Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 13:29 To: 'Yves Arsenault'; Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB insertion What operating system does the MySQL server reside? The ASCII representation for é is 233. Is this the same value for the host machine? -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 11:27 AM To: Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB insertion The è caracter is being changed to a square... Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 13:19 To: 'Yves Arsenault'; 1Mysql Subject: RE: Loosing "é" characters in DB insertion Are the é being replaced by another character? -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 10:05 AM To: 1Mysql Subject: Loosing "é" characters in DB insertion Hello, I just took over a site from a client, he used an Access DB, the Database contains mostly french text... I've created a dump file to transfer the DB to MySQL, but when I execute the code, the é characters are lost. They're being created as VARCHAR.. I'm not a very experienced MySQL user. Is there anything I should look for in the dump file? -- 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: Loosing "é" characters in DB insertion
Red Hat 9. Looking at the data through Webmin, it appears as though the text is correct in the DB in certain fields, in some others, there are strange characters... I think the clients db may have had slight errors... In any effect, the web interface that is run off this DB doesn't display the 'é' characters.. Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 13:29 To: 'Yves Arsenault'; Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB insertion What operating system does the MySQL server reside? The ASCII representation for é is 233. Is this the same value for the host machine? -----Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 11:27 AM To: Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB insertion The è caracter is being changed to a square... Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 13:19 To: 'Yves Arsenault'; 1Mysql Subject: RE: Loosing "é" characters in DB insertion Are the é being replaced by another character? -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 10:05 AM To: 1Mysql Subject: Loosing "é" characters in DB insertion Hello, I just took over a site from a client, he used an Access DB, the Database contains mostly french text... I've created a dump file to transfer the DB to MySQL, but when I execute the code, the é characters are lost. They're being created as VARCHAR.. I'm not a very experienced MySQL user. Is there anything I should look for in the dump file? -- 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: Loosing "é" characters in DB insertion
The è caracter is being changed to a square... Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 13:19 To: 'Yves Arsenault'; 1Mysql Subject: RE: Loosing "é" characters in DB insertion Are the é being replaced by another character? -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 10:05 AM To: 1Mysql Subject: Loosing "é" characters in DB insertion Hello, I just took over a site from a client, he used an Access DB, the Database contains mostly french text... I've created a dump file to transfer the DB to MySQL, but when I execute the code, the é characters are lost. They're being created as VARCHAR.. I'm not a very experienced MySQL user. Is there anything I should look for in the dump file? -- 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]
Loosing "é" characters in DB insertion
Hello, I just took over a site from a client, he used an Access DB, the Database contains mostly french text... I've created a dump file to transfer the DB to MySQL, but when I execute the code, the é characters are lost. They're being created as VARCHAR.. I'm not a very experienced MySQL user. Is there anything I should look for in the dump file? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Access to MySQL
Thanks to all who replied! I was just looking at MySQL Front. Thanks all, Yves Arsenault Carrefour Infotech 5, Acadian Dr. Charlottetown, PEI C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED]] Sent: December 17, 2002 12:24 PM To: 'Charles Mabbott'; [EMAIL PROTECTED]; '1Mysql' Subject: RE: Access to MySQL There are many tools. Use a gui. mysql front (free), premium soft (my pick but has a 29 day trial). There are also many small window applications to do this. Do a search at one of the famous downloads. +client +mysql +gui -Original Message- From: Charles Mabbott [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:45 PM To: [EMAIL PROTECTED]; '1Mysql' Subject: RE: Access to MySQL Yves, I am always open for cleaner method, but what I did was in MySQL created a table 'member' for data. In Access exported as .txt make sure tab sequential. Back in MySql I made database active that had 'member' And did a: >mysql load data infile "c:\\mysql\\tmp.txt" into member; it actually went in quite cleanly. I am sure there are probably better ways, I am always willing to learn. But this is what worked for me today. Regards, Chuck -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:21 PM To: 1Mysql Subject: Access to MySQL Hello, Is there a small program that would transfer the contents of an Access database to MySQL? TIA, Yves Arsenault Carrefour Infotech 5,promenade Acadian Charlottetown, IPE C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 ICQ #117650823 - 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 - 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
Access to MySQL
Hello, Is there a small program that would transfer the contents of an Access database to MySQL? TIA, Yves Arsenault Carrefour Infotech 5,promenade Acadian Charlottetown, IPE C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 ICQ #117650823 - 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
Unique identifier in MySQL
Hello, Hope this makes sense, I am totally new with using MySQL. How would I create a unique ID number for a table, for, say, a field named UserID for example? Thanks Yves - 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