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
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 |
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:
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
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
On 12/16/2003 01:35 AMnbsp;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
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
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 servers
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
://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.mysql.com/support/index.html
- Alkuperäinen viesti -
Lähettäjä: Adam Hardy [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri
you need to put mysql-connector-javax in tomcat/common/lib and then
specify
parameter
namedriverClassName/name
valuecom.mysql.jdbc.Driver/value
/parameter
in your server.xml
Adam
On 10/03/2003 04:35 PM Dan Greene wrote:
I got it working... unfournately it's on
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
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
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: Adam
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
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.
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
17 matches
Mail list logo