Re: My backup scripts and how reliable are they?

On 02/26/2004 09:02 AM Scott Haneda wrote: As per the reco of someone on this list, I created a bash script that runs once a day to do the following: # set path to final destination location="/Volumes/foo/sql_dumps/" # set db_list to the list of databases db_list=`echo "show databases" | /usr/local

Re: A question about mysql database backup.

On 02/25/2004 09:13 AM Frederic Wenzel wrote: Now I am assigned to do the backup of a whole mysql database (version: 3.23.36). I want to make sure whether the following procedures are correct for database backup. 1. mysqldump -F --opt database_name > database_name.backup In my opinion, you shou

Re: German Language characters storage.

On 02/24/2004 04:45 PM Michael Johnson wrote: Can MySQL store German characters such as ä, o, u and ß Yes it can. It can store anything digital. It's what you program that counts. :) Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:/

max key length 500 in myisam index

I've got to create a table that has the following: CREATE TABLE access ( query VARCHAR(255) NOT NULL, INDEX (query) ); and mysql is telling that the max bytes allowed is 500 for key length. The docs say I can change this by recompiling, which I would like to avoid having to do. Is there any

netstat

I'm running a web server with Apache Tomcat and mySQL for the first time and I've been following various recommendations to make the server more secure (it's Linux Debian). One of these recommendations is to keep the number of open ports to a minimum. I'm looking at netstat (see the output belo

Re: UTF-8 support

On 12/16/2003 01:35 AM Ligaya Turmelle wrote: Can anyone tell me what the current support for the UTF8 character set is? How strong is it? Do I have to do anything special to save the characters? I will be getting the characters from a webpage form and inserting the characters with PHP. It depends

adding first users in user table

Hi Listers, I have just installed mysql following the instructions for the binary distro under linux and I added my root user and password using mysqladmin as mentioned in scripts/mysql_install_db. In the mysql.user table I see my [EMAIL PROTECTED] and [EMAIL PROTECTED] but I also see two entri

Re: back up database

On 11/12/2003 02:58 AM Didier Godot wrote: Hi everyone, this is my first post, you will excuse me for my english cause french is my fluent language. So i'm also new to mysql, tonight my question is how to make a back up of all the database on MySQL 4.0.12 running on netware server 6 i hava

Re: running 4.0.15 side-by-side with 4.1alpha

On 11/11/2003 09:21 AM Egor Egorov wrote: Adam Hardy <[EMAIL PROTECTED]> wrote: I am sure I say someone asking a similar question on the list before but I can't find anything in the archives, nor anything relevant in the mysql docs. You can find info how to run multiple MySQL

running 4.0.15 side-by-side with 4.1alpha

Hi, I am sure I say someone asking a similar question on the list before but I can't find anything in the archives, nor anything relevant in the mysql docs. Is it possible to have two versions of mysql running side-by-side on linux and if so, are there any installation instructions anywhere? I

Re: can NOT drop the database

http://www.innodb.com/ibman.html#InnoDB_troubleshooting_dict to resolve the problem. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for MySQL Order MySQL support from http://www.mysq

Re: Tomcat, Connection Pooling, and MySQL

you need to put mysql-connector-javax in tomcat/common/lib and then specify driverClassName com.mysql.jdbc.Driver in your server.xml Adam On 10/03/2003 04:35 PM Dan Greene wrote: I got it working... unfournately it's on my laptop at home, not here at work with

Re: can NOT drop the database

Hi Heikki, a similar problem happened to me and I got the error: ERROR 1051: Unknown table '#sql-ffa_2,#sql-2b2_30' After reading your post, I checked in the data directory and there are two files there, both of file type data: #sql-2b2_30.frm #sql-ffa_2.frm I certainly didn't put them there m

1051: Unknown table on running drop database

I'm getting this error: ERROR 1051: Unknown table '#sql-279_28,#sql-333c_1' after trying to drop a database. I found nothing in the docs or the archives about how to sort it out. Can anybody tell me what steps I should take to remedy this? I'm using 4.1.0 Thanks, Adam -- MySQL General Mailing

Re: Character set problem Linux - Windows

From a quick search of the online docs, it seems this is what you need: http://www.mysql.com/doc/en/Charset-CONVERT.html but I think it is only in 4.1.0 alpha. Feel free to correct me, I'm no guru here. Adam On 09/18/2003 12:06 PM Marcin Giedz wrote: - Original Message - From:

Re: Character set problem Linux - Windows

Hi Marcin, have you tried using unicode? Adam On 09/17/2003 02:02 PM Marcin Giedz wrote: Hi all, My company(situated in Poland) produce cross platform software based on Borland Delphi/Kylix. We also use mysql server to store all our date.Server is configured with latin2 character set. Nowadays se

SQL syntax on an UPDATE

Hi All, I'm programming a method to delete a parent record and all its children in a child table in one go. This is what I have: UPDATE item i, category_item ci SET i.date_deleted = ?, ci.date_deleted = ? WHERE ci.item_id = i.item_id AND ci.category_id = ? and it works. But then I realised that

Re: How can I select the column names?

Hi Jake, I think I know what you mean, but it depends on how you access your db. You want the metadata - in JDBC you would go something like this: metaData = resultSet.getMetaData(); colName1 = metaData.getColumnName(1); On 09/04/2003 02:50 PM Fortuno, Adam wrote: I don't follow your question.