Chris,
- Original Message -
From: Chris Nolan [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, February 12, 2004 2:45 AM
Subject: InnoDB Hot Backup + MySQL embedded?
Hi all,
I'm looking at developing an (open source) server-style application with
the embedded
Hi,
SELECT COUNT(*) for InnoDB tables is a know problem... The table
handler (for InnoDB) has to do a table scan to count all rows... This
particular case is optimized with MyISAM ...
Sure. But why is the tablescan ~100 times faster for the table without the
BLOB column?
This goes back to
Hello
I am looking for software/hardware solutions to provide loadbalancing
and redundancy for mysql databases.
Today we are running 6 separate servers with mysql and each have around
100-200 databases each. But they are not loadbalanced or redundant, so
if one machine goes down...well you
Bryan Brannigan [EMAIL PROTECTED] wrote:
I'm having difficulty getting binary logging to run. My system is a Debian 3.0r2
system running MySQL-server 4.0.16-log. I have added log-bin to my my.cnf file.
However, when I restart MySQL I don't get a binary log anywhere. When I run SHOW
Daniel Audette [EMAIL PROTECTED] wrote:
I would like to create a user that can create databases and do all the
necessary changes to it(select, insert, update, delete...), view all
database that he has been granted to see by other users except the
mysql.* I have created 1 user with the grant
Adam,
use the mysql client tool.
yourbox mysql -h host -u user -pPasswd yourdatabase sqlfile.sql
Cheers, Thomas Spahni
On Thu, 12 Feb 2004, Adam Staunton wrote:
Hi all,
I have an sql file that I exported from a database of mine that has over
3000 lines (records) in it. How do I go about
Hello guys!
Just wanted to tell you, how pleased i am to see that you just released
a alpha version of the mysql administrator! =) I am currently
downloading the linux version!
Just wanted to say thanxs, personally, for such nice products!
Best Regards!
--
Hello
I've got a big problem. My MySQL server has yesterday lost data since 20th
january.
Fact, we got a daily tape backup. All our tapes (monday - friday tapes,
oldest one is we 04th feb)
are holding the database of 19th january evening.
Yesterday at about 14 o'clock we resartet the
Michael McTernan wrote:
Hi,
SELECT COUNT(*) for InnoDB tables is a know problem... The table
handler (for InnoDB) has to do a table scan to count all rows... This
particular case is optimized with MyISAM ...
Sure. But why is the tablescan ~100 times faster for the table without the
Dear Heikki,
Thanks for the quick response! It never ceases to amaze me that such
compartively small teams at Innobase Oy and MySQL AB produce such
incredibly high-quality software.
Being a final-year Software Engineering student, I'm curious as to what
you consider the most difficult problem
First and foremost, your English is not even remotely bad! You should
hear half of my native-English speaking friends!
Can you give us some more information, such as the server configuration,
OS, filesystem, MySQL version, table types in use, table size, size of
the data gone missing, backup
Hi!
You might want to keep your eye on MySQL Cluster - to be demonstrated at
the 2004 MySQL conference, where you might get a chance to swim with the
dolphins!
Regards,
Chris
Are Pedersen wrote:
Hello
I am looking for software/hardware solutions to provide loadbalancing
and redundancy for
Hi Mysqlers,
I have a table which implements a tree-like heirarchy:
In the example below a geographical heirarchy.
I would like to be able to pick a node in the tree and
Get everything logically below that node in the heirarchy:
(A self join?)
#
# Table structure for `tree`
#
CREATE TABLE
Michael McTernan wrote:
Hi,
SELECT COUNT(*) for InnoDB tables is a know problem... The table
handler (for InnoDB) has to do a table scan to count all rows... This
particular case is optimized with MyISAM ...
Sure. But why is the tablescan ~100 times faster for the table without the
Say I have two tables, and they have several column names that are the same
in both tables. I know I can manually alias the column names so that they
don't overlap, but is there a way to prefix *all* of the columns of one
table so that I can be sure the names don't overlap?
So if I have these
SELECT
person.*,place.* as home_*
FROM
person,place
WHERE
person.home_id = place.id
AND
name = 'Joe'
What if more of your tables have a column name?
To get back results like:
id,name,age,home_id,home_name,home_zip_code
The problem is that I don't want to have to update my
This is strange. I've tried to set up a second mysqld to run, but it
fails. Well, fails isn't quite the right word, it simply exits immediately.
/usr/local/mysql4017/bin/mysqld_safe -v --basedir=/usr/local/mysql4017
--defaults-file=`pwd`/my.cnf --socket=/tmp/mysql2.sock --port 12225
I have a database with two tables (well more but only two are important
here)
When a risk is created it can have one or more plans (hence the second
table) The data that is inserted comes from a cgi form. So I want to
insert all risk data into risk_tb and plan_tb.
The question is how do I
Hi,
I tried to do replication from master- slave, I used windows,
MySql 4.0.17 version on both. I have set bin-log option
in my.cfg in master computer, set master-host, master-user, master-password,
replicate-do-db and replicate-ignore-db=mysql, skip-slave-start in
my.cfg in slave. I have zipped
Hello, I have been fiddeling with MySQL5 alpha for a little testing sessions but I
kept my MySQL4 installation. The problem is that I cant set the path for my my.cnf
file for MySQL5. I can use my.cnf if I put in /etc but then it conflicts with my other
MySQL installation. Does anyone have a tip
On Thu, 12 Feb 2004, Martijn Tonies wrote:
SELECT
person.*,place.* as home_*
FROM
person,place
WHERE
person.home_id = place.id
AND
name = 'Joe'
What if more of your tables have a column name?
then:
person.*,place.* as home_*,thing.* as thing_* (etc...)
The problem is
Use LAST_INSERT_ID() to get the id. LAST_INSERT_ID() is
connection-specific, so you will get the correct value regardless of
other users.
See http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html for more.
Michael
David Johnston wrote:
I have a database with two tables (well more but only
What message is being logged to the error log?
Original Message
On 2/12/04, 8:32:20 AM, Greg G [EMAIL PROTECTED] wrote regarding Second
mysqld fails...:
This is strange. I've tried to set up a second mysqld to run, but it
fails. Well, fails isn't quite the right word, it simply exits
What is the output from show slave status?
Original Message
On 2/12/04, 8:43:44 AM, Liying Huang [EMAIL PROTECTED] wrote
regarding question for replication:
Hi,
I tried to do replication from master- slave, I used windows,
MySql 4.0.17 version on both. I have set bin-log option
in
Hello,
we are currently running MySQL 4.0.15 w/InnoDB tables on a RH/Linux 9.0 and
would like to upgrade. the current RPM's installed are:
MySQL-client-4.0.15-0
MySQL-embedded-4.0.15-0
MySQL-devel-4.0.15-0
MySQL-shared-compat-4.0.15-0
MySQL-shared-4.0.15-0
MySQL-server-4.0.15-0
Hi,
Well, two possible explanations... BLOBS are either stored in a
separate area thus forcing MySQL to perform an extra seek to retrieve
the full row or the table scan takes a lot more time to execute because
of the BLOB data you have to retrieve...
I'm not often retrieving the BLOB value
Hello,
we are currently running MySQL 4.0.15 w/InnoDB tables on a RH/Linux 9.0 and
would like to upgrade. the current RPM's installed are:
MySQL-client-4.0.15-0
MySQL-embedded-4.0.15-0
MySQL-devel-4.0.15-0
MySQL-shared-compat-4.0.15-0
MySQL-shared-4.0.15-0
MySQL-server-4.0.15-0
Hi,
Is there any length limit for the field name or it is not good to define
a field name like my_field_name_is_this_size_plus_a_little_bit_more ?
Thanks.
--
Andre Matos
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Liying Huang [EMAIL PROTECTED] wrote:
Hi,
I tried to do replication from master- slave, I used windows,
MySql 4.0.17 version on both. I have set bin-log option
in my.cfg in master computer, set master-host, master-user, master-password,
replicate-do-db and replicate-ignore-db=mysql,
Hi,
Is there any length limit for the field name or it is not good to define
a field name like my_field_name_is_this_size_plus_a_little_bit_more ?
I believe the limit it 64 characters.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL
Show slave status:
*** 1. row ***
Master_Host: lhuang
Master_User: test
Master_Port: 3306
Connect_retry: 60
Master_Log_File: lhuang-bin.001
Read_Master_Log_Pos: 79
Relay_Log_File:
Was the update peformed in either the WITCD or WITTD database?
Original Message
On 2/12/04, 9:52:57 AM, Liying Huang [EMAIL PROTECTED] wrote
regarding Re; Re: question for replication:
Show slave status:
*** 1. row ***
MySQL 4.1.1
Connector/j 3.1 nightly - 20040212
I recently upgraded to MySQL 4.1 and am trying to get connector/J to
work. I downloaded the 3.1 nithly build from 20040212 and start mysql
4.1 with the --old-passwords option. I also ran
mysql_fix_privilege_tables option. MyODBC does work
My replicate-do-db=db1, db2, let me make db1 to be
current database to see if the query will update or not.
If update, then you probably solve my problem.
Thanks.
Liying
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 12,
Jonas Lind?n [EMAIL PROTECTED] wrote:
Hello, I have been fiddeling with MySQL5 alpha for a little testing sessions but I
kept my MySQL4 installation. The problem is that I cant set the path for my my.cnf
file for MySQL5. I can use my.cnf if I put in /etc but then it conflicts with my
I just use update *** set *** query on WITCD, Victoria might
find out the problem for me, I didn't specify database in query,
if database is not current, the query will not be updated. I
am trying to use one database to be current for both master
and slave, and see if query will update slave or
It only update WITCD. I finish the switching, query still doesn't
update in slave.
Liying
- Original Message -
From: [EMAIL PROTECTED]
To: Liying Huang [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, February 12, 2004 11:00 AM
Subject: Re: Re; Re: question for replication
Was
I have done use WITCD in both master and slave to switch it to be
current database.
Then I do, update tabel1 set SOURCE_APERTURE=1000 where TOOL_PK=4 in master.
I saw witcd update tabel1 set SOURCE_APERTURE=1000 where TOOL_PK=4
in slave-realy-bin.001, but database in slave didn't get update. :.
Andre MATOS [EMAIL PROTECTED] wrote:
Is there any length limit for the field name or it is not good to define
a field name like my_field_name_is_this_size_plus_a_little_bit_more ?
Column name is limited to 64 characters.
--
For technical support contracts, goto
The .err file in var2 says:
040212 09:30:23 mysqld started
/usr/local/mysql4017/libexec/mysqld Ver 4.0.17 for sun-solaris2.7 on sparc (Source
distribution)
040212 09:30:24 mysqld ended
That's it.
-Greg g
[EMAIL PROTECTED] wrote:
What message is being logged to the error log?
Original
I stopped both server, clean all log, master.info etc files in
mysql\data. And changed repicate-do-db=WITCD,
one database this time, start servers in both computer,
use WITCD in both computer, start slave in slave
computer, then do an update in master (same query),
no update in database for slave
I am implementing Hotbackup for innodb .
My question is when the tables in the database directory so *.frm are
deleted by mistake will they be recovered by the hotbackup script?
Hi,
I believe I've done everything from the book and have been fighting with
the same problem for about 6 hours thus far.
I just upgraded from MySQL 3.23.56 to 4.0.17. In the old system, I
prevented show databases from ordinary users using skip-show-databases. In
order to upgrade I used
Hi there,
I would try to sum it up like this:
1. Discs work best when used as purely sequential devices.
2. Inserting those BLOBs takes up space somewhere. Strictly speaking, on
the disc they may very well be in between certain rows.
Good points - I guess there is no way for the database to
I receive the following warning in my hostname.err file after upgrading
from 3.23.56 to 4.0.17. Any ideas what's causing it and how to fix it?
Warning: Asked for 196608 thread stack, but got 126976
Trying to find the source- maybe a setting is too high? Linux 2.4.x
Thanks in advance,
-M
Good Morning!
I'm trying to get MySQL 4.0.15 running on a new SuSE linux PC. This is
my first attempt installing on SuSE after setting up a large number of
Red Hat machines without problem. Right now, however, I'm continually
receiving errors that I just don't understand where they are
Michael McTernan wrote:
Hi there,
I would try to sum it up like this:
1. Discs work best when used as purely sequential devices.
2. Inserting those BLOBs takes up space somewhere. Strictly speaking, on
the disc they may very well be in between certain rows.
Good points - I guess there
Hello People,
This is my first post to this list. I am having a bit of a problem that
Google doesn't seem to help with, and I'm not sure what part of Mysql
docs will help.
I have a very large web app that uses timestamp for unique IDs.
Everything was rolling fine until we started getting many
You definitely don't want to use timestamping for unique
IDs. You want to use an auto-incrementing column or similar.
See
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
Eamon Daly
NextWave Media Group LLC
Tel: 1 773 975-1115
Craig Jackson [EMAIL PROTECTED] wrote:
I have a very large web app that uses timestamp for unique IDs.
Everything was rolling fine until we started getting many users per
second, causing some of the unique IDs to not be unique -- users were
being assigned the same timestamp. Since the web app
You have a design flaw in your database, using timestamp as a unique
ID. There really is no work around. You can't reliably keep using
timestamps for unique IDs. As a rule, a unique ID should not be
dependent on anything else and should not represent anything else aside
from a unique id. For
On Thu, 2004-02-12 at 11:47, Keith C. Ivey wrote:
Craig Jackson [EMAIL PROTECTED] wrote:
I have a very large web app that uses timestamp for unique IDs.
Everything was rolling fine until we started getting many users per
second, causing some of the unique IDs to not be unique -- users
Hi Chris,
A HEX editor? :-) Finding out what the developers at MySQL AB like to
drink and sending them a few megalitres of it? :-)
Heh heh :-)
In all seriousness, you haven't got a great many options (although I
could be completely wrong, in which case some kind person on this list
will
Apache2 and php is a buggy combination? Not that I have seen.
Or are you referring to trying to use the Apache Worker (mutlithreaded)
MPM with php... I believe that is still a bit buggy, though, no rpms or
packages seem to install it that way anyways. I'm hoping to get
workerMPM working for
code it within your program. If this is in fact a primary key (whcih you
seem to describe it as), then it should be distinct anyway. So do an INSERT
IGNORE or even just an INSERT. It will fail upon duplicates. Check the
affected rows or the insert_id (using whatever API you use to access
Add a second field that is auto incremented and change the primary key to
that
So for now you can keep the time-stamp
Thanks,
Nalaka Nanayakkara
Overwaitea Food Group
Tel: 604-888-1213 (ext 3742)
-Original Message-
From: Craig Jackson [mailto:[EMAIL PROTECTED]
Sent: Thursday,
Thx' Alex.
do the old RPM's need to be removed first before upgrading ??
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Pippin wrote:
MySQL 4.1.1
Connector/j 3.1 nightly - 20040212
I recently upgraded to MySQL 4.1 and am trying to get connector/J to
work. I downloaded the 3.1 nithly build from 20040212 and start mysql
4.1 with the --old-passwords option
On 12 Feb 2004 at 11:57, Craig Jackson wrote:
Thanks for the speedy reply and I have already recommended
auto_increment for the solution. We do need that quick fix until the
problem is fixed. How would I go about making Mysql wait one second
between inserts. We only get about 1000 hits per
The _only_ real benefit of Apache2 over Apache1 is it's thread-based model.
So why leave a stable, tried-and-true, robust Apache1 platform for no
additional benefits at all? Why break compatibility? Why use the Apache2
branch if you don't need it?
PHP itself works quite fine in a threaded
Title: Size v Speed
Afternoon all,
This is my first post and I have a quick question for you MySQL experts out there. I am running a Red Hat 9 Linux box (2GHz, 1GB of RAM) specifically designed for running a MySQL database. This database is already over 3GB in size with over 120M records
Thx' Alex.
do the old RPM's need to be removed first before upgrading ??
You can just do:
rpm -Uvh MySQL-*
in the directory with the new RPM's in - this will overwrite the old packages
with the new ones.
-- Alex
--
MySQL General Mailing List
For list archives:
Hi, i'm a new user.
I copied a db in the mysql db path but when I try to use database I obtain :
didn't find any fields from table ...
for each table. What may I do to read the database?
I read the documentation but I didn't find any solution.
Thanks.
Mic
I'm using apache 2, and I'm not having any problems with it at all. It's a
little weird trying to get it configured the first time, but other than that
it's not bad. We have found that it can push a little more bandwidth and
the load seems to be a little lower than 1.x. But then again we are
What are you transferring this database from? Access, FoxPro? Intelligent
Converters (convert-in.com) has some great tools for transferring databases,
but you will need to copy the data yourself.
Have you downloaded the MySQL Control Center or MySQL Administrator? Both of
these tools will enable
as everyone has pointed out, using timestamps as a unique id was a
design flaw. you should fix the problem using an auto-increment field.
that said, can you change the column type you are currently using as a
timestamp to be an auto-increment int field? the return type in both
cases is
I want to make backup from my InnoDb tables as far as i understand todo
this when the database can't be down to use InnoDB HotBackup.
I was reading the manual and it said:
You can also simply copy all table files (`*.frm', `*.MYD', and `*.MYI'
files) as long as the server isn't updating
Are the files in the directory owned by mysql?
You get this error if mysql can't read the .FRM file.
michele digioia wrote:
Hi, i'm a new user.
I copied a db in the mysql db path but when I try to use database I obtain :
didn't find any fields from table ...
for each table. What may I do to read
InnoDB uses a single file (filename.frm) for each table and then stores
other database information in an InnoDB general file, named in your
innodb_data_file_path=innodbdata:xxM
Hope this helps a little!
J.R. Bullington
Innovatim Technical Support
[EMAIL PROTECTED]
--
MySQL General Mailing
Is it possible to have a 'worked out value' in the WHERE clause. The problem
I have is what I need to check for in the WHERE Clause is not a column:
SELECT
CONCAT_WS(-,DATE_FORMAT(EntryDate,'%c'),DATE_FORMAT(EntryDate,'%Y')) As
mthyr
From Blogs
WHERE mthyr=1-2003
This does not work as it seems
No, InnoDB hot backup only backs up the table data, not the definitions.
You need to back those up separately. This is all explained here:
http://www.innodb.com/manual.php#Backing_up_myisam_and_innodb
There's also a perl script that can help you with the backup. Even
though it says MyISAM, you
Ian ORourke said:
Is it possible to have a 'worked out value' in the WHERE clause. The
problem I have is what I need to check for in the WHERE Clause is
not a column:
SELECT
CONCAT_WS(-,DATE_FORMAT(EntryDate,'%c'),DATE_FORMAT(EntryDate,'%Y'))
As mthyr
From Blogs
WHERE mthyr=1-2003
This
You can use having instead of where with an alias.
Bernard
On Thursday 12 February 2004 14:46, Ian O'Rourke wrote:
Is it possible to have a 'worked out value' in the WHERE clause. The
problem I have is what I need to check for in the WHERE Clause is not a
column:
SELECT
Ian O'Rourke wrote:
Is it possible to have a 'worked out value' in the WHERE clause. The problem
I have is what I need to check for in the WHERE Clause is not a column:
SELECT
CONCAT_WS(-,DATE_FORMAT(EntryDate,'%c'),DATE_FORMAT(EntryDate,'%Y')) As
mthyr
From Blogs
WHERE mthyr=1-2003
HAVING
Hello,
I would like to know what version of MySQL will work on Solaris 2.9
Nathaniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manual startup using the unix
commands as detailed in the manual. I kept getting the message mysql
shutting down before I could hit ctl-Z. Then when I tried to connect,
it stated:
Hi
Using MySql V4.x
If I use this
SELECT * FROM marriage WHERE groom_surname like (' globsurname ')
and community like (' community ')
I get the results I expect
And if I use this it also works fine
SELECT * FROM marriage WHERE bride_surname like ('
On Thu, 12 Feb 2004, John Berman wrote:
Try adding some ()s:
SELECT * FROM marriage WHERE (groom_surname like (' globsurname ') or
bride_surname like (' globsurname ')) and community like (' community
')
--
--
MySQL General Mailing List
For list archives:
It's been my experience that adjacency lists like what you describe are
difficult to query. I have had success with nested sets to represent
that kind of hierarchical data.
More information at:
http://users.starpower.net/rjhalljr/Serve/MySQL/traer.html
-Original Message-
From: Joe
I assume when you tried to start MySQL from the command line you used
safe_mysqld. You may not be seeing the error messages that would tell
you why it's not starting. Try starting mysql directly.
cd /usr/local/mysql
sudo ./bin/mysqld
You'll probably see an error message that is a bit more
Ahh so it evaluates the expression with in the brackets first ( I vaguely
remember my math's teacher mention this some 40 years ago, should have
listened)
Regards
John B
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 12 February 2004 21:23
To: [EMAIL
I can't really speak to OLEDB optimization, but I can speak to changing
over to PHP.
The MySQL database connector in PHP is pretty good from a performance
standpoint, and PHP itself is blazing fast in my experience. I've seen
massive performance gains in PERL by creating an abstraction that
Marty Ray wrote:
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manual startup using the unix
commands as detailed in the manual. I kept getting the message mysql
shutting down before I could hit ctl-Z. Then when I tried to
I tried what you suggested and I got:
---
G5-Computer:/usr/local/mysql martyray$ sudo ./bin/mysqld
Fatal error: Please read Security section of the manual to find out
how to run mysqld as root!
040212 17:02:44
Marty Ray
This should help you out - http://www.entropy.ch/software/macosx/mysql/
I just downloaded and installed mysql 4.1.1 on a Macintosh G5, but I
cannot get it to start up. I first tried manual startup using the unix
commands as detailed in the manual. I kept getting the message mysql
Okay, I tried all of that and I still couldn't connect.
Here is what I got from the .err file:
040212 15:54:38 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040212 15:54:38 InnoDB: Setting file ./ibdata1 size to 10 MB
You have to re-run the ./scripts/mysql_install_db
I had this exact error and it comes from deleting (or not installing) the
'mysql' database, which is a required component for MySQL to run. It also
installs a db called 'test' which is not required.
J.R. Bullington
Innovatim Technical Support
I really appreciate all the help! I tried running
./scripts/mysql_install_db and this is what I got:
G5-Computer:/usr/local/mysql martyray$ ./scripts/mysql_install_db
mkdir: ./data/mysql: Permission denied
chmod: ./data/mysql: Permission denied
mkdir: ./data/test: Permission denied
chmod:
K. Here are the step-by-step instructions that might help.
1 - Download and unpack the tar.gz file from mysql.com/downloads
2 - Open the Users panel and add a new user called 'mysql' with whatever
password you choose.
3 - Open Terminal.app and log on as root
4 - [/] root# cd /usr/local/mysql (or
Okay! Thank you all for the help!
'j.e.b.' suggested looking at the help info at the link below. That did
the trick. I was able to go through that info an troubleshoot my
problem.
You folks are great. A lot of experts are less than tolerant of
beginners. I feel welcome here and I appreciate
Hello MySQL email listers,
Success at last. The tips i received from the MySQL list, got me on track.
Finally got the PHP and MySQL set up correctly, thanks to the help from
this
list.
Thanks Again,
Eric
[EMAIL PROTECTED] wrote:
On 11-Feb-2004 Eric W. Holzapfel wrote:
Hello Listers,
I
Hi,
I am currently migrating data DIRECTLY from a microsoft sql server 7
database into a mysql database. The sql database supports strings in
different languages(Japanese French, spanish and so on). The sql 7 database
has been setup to support unicode.
1. How do I create a databese to
Brace yourself for another beginner question...
When I try to use the SHOW command (logged in as root) , I get an error:
mysql show databases;
ERROR:
No query specified
Any suggestions?
Thanks!
Marty Ray
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Greetings All,
My name is Zak Greant. I work for MySQL AB as their community advocate
- I am also helping to organize the content for our upcoming MySQL User
Conference (http://mysql.com/events/uc2004) that is happening in April.
Our deadline for choosing the final list of sessions is a couple
Greetings All,
My name is Zak Greant. I work for MySQL AB as their community advocate
- I am also helping to organize the content for our upcoming MySQL User
Conference (http://mysql.com/events/uc2004) that is happening in April.
Our deadline for choosing the final list of sessions is a couple
Hi,
Two way, depending on size of Your data ...
- programming if data is more than 64MB
- best way - export MS SQL 7 to MS Access and import MS Access to MySQL (my
experience is only char.data, no image in blob or other things like this)
Best regards
Peter W Rasmussen
- Original Message
I like the auto-increment primary key method for unique ID's in MySQL, however, if
your table's design will not allow you to use that for some (unknown to me) important
reasons, you could programmatically generate a truly unique ID and INSERT that.
Did you try a Google under GUID?
Craig,
Instead of delaying a second, why not just add a second to the timestamp?
The following should work just fine:
create table tst (ts timestamp primary key, other_stuff varchar(127) not
null);
...
insert into tst
select greatest(now(), max(T.ts) + interval 1 second)
, value of
Hi Craig,
I have a very large web app that uses timestamp for unique IDs.
Everything was rolling fine until we started getting many users per
second, causing some of the unique IDs to not be unique -- users were
being assigned the same timestamp. Since the web app is so large we
don't want
Hi,
Recently I've been seeing the following kind of error message for several of
the MyISAM tables in my database:
General error: Can't open file: 'build_packages.MYI'. (errno: 145)
Running a simple repair operation on the corrupted table will make MySQL
happy again, even though the repair
100 matches
Mail list logo
