Hi all, can some body help me ... ?
I have a problem to insert string which is contain semicolon to mySQL Database.
For your info :
When I try to insert string which is contain semicolon to mySQL in
the free webserver www.f2s.com (see my project http://www.verisdev.f2s.com ),
I have no problem, b
Hi, David!
Try to write your query without "order by ..". Sort operations need a
lot of memory.
But, if you want to use sorting, try to split your big table to smaller
tables.
Dmitri Lubinski
-Original Message-
From: David Keeney [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 6:
Hi!
It's my variant. Try to use it.
select sex, age, count(*)
...
group by sex, age
Dmitri Lubinski
-Original Message-
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 11:38 PM
To: [EMAIL PROTECTED]
Subject: Dinstinct query
I have two fields, sex, and age, whi
Seems that you are not taking advantage of Perl. This is what you can do:
$parentid = x;
$orderby = 'DESC';
my $sth = $dbh -> prepare (qq{
SELECT message.name, contents, user.name, message.id
FROM message, user
WHERE folder='N' and parentid=$parentid
GROUP B
Simple answer: you can't do that.
The ? is only for WHERE parameters. You need to have two differnt queries
(or one query, and concatanate the desired sort command).
j- k-
On Monday 09 July 2001 21:13, havoc wrote:
> I'm having some trouble passing some information from my Perl script
I just changed a column type (timestamp --> date) in PHPmyadmin, but
when I checked the table structure in the mysql client immediately
afterwards, it showed up with the old column type!!
Has anyone else had something like this happen?
How can PHPmyadmin and the mysql client show different out
I'm having some trouble passing some information from my Perl script to
the DBI query interface.
A short version of my query would look like:
my $sth = $dbh -> prepare (q{
SELECT message.name, contents, user.name, message.id
FROM message, user
WHERE folder='N' and paren
[EMAIL PROTECTED] wrote:
> what is the [MySQL] command to change an existing db name?
No command for this but this is in our TODO list.
> (is there a book or manual with straightforward question and answer like
> this?)
> Before posting, please check:
> http://www.mysql.com/manual.php
suh wrote:
> I meet in share ver. of MySQL different lang. driver but no where
> UKRAINIAN.
> AND now I ask - I wont translete "errmsg.txt" and "errmsg.sys" for
> UKRAINIAN lang?
>
> Waiting for ansver!
Just translate errmsg.txt and send it to us.
--
For technical support contracts, got
Does somebody know what might be wrong here? I'm running RedHat Linux 7.1,
and fltk installed properly.
[root@mach fl_editor-0.4.1]# make
Compiling src/Fl_Editor.cxx...
c++ -I. -I/usr/local -g -O2 -I/usr/X11R6/include -c src/Fl_Editor.cxx -o
src/Fl_Editor.o
In file included from src/Fl_Editor.
Wouldn't that depend on if the MySQL db is on the same server as the web
servers and the scripts that connect to them. It could also depend on if
the scripts use the -h option when making a connection and if this is the
ip address (as in number) or is a resolvable name. If it is all local, if
Probably doesn't really matter much, but I figured I'd report it at least.
010703 20:18:44 Aborted connection 112650 to db: 'unconnected' user: 'xxx' host:
`xx' (Got error %d from table handler)
010703 20:18:46 Aborted connection 112651 to db: 'unconnected' user: 'xxx' host:
`
I am having a problem accessing databases on the local machine.
The user table is setup as such
| % | steve | 42eacf9a6ed6afa4 | N | N
| N | N | N | N | N | N
| N| N | N | N | N
Sorry. I omitted an important detail from the previous post:
I have a database of almost 6 million records, and 1.5 Gbyte table
size. I need to iterate over the table with a Perl script, examining
every record.
This code :
$sth_gnr = $dbh->prepare(
'SELECT SQL_BIG_RESULT * FROM Tiger_main '
I have a database of almost 6 million records, and 1.5 Gbyte table
size. I need to iterate over the table with a Perl script, examining
every record.
This code :
$sth_gnr = $dbh->prepare(
'SELECT SQL_BIG_RESULT * FROM Tiger_main '.
"WHERE rdid > '' ".
'ORDER BY rdid
Changing your IP address shouldn't affect your MySQL access in that way. I
would say you have done something else to cause those errors. You can look
at skip grants in the manual. From what you have written, your web pages
are accessing the DB as root. That spells D A N G E R. You should crea
At 6:10 PM -0500 7/9/01, ryc wrote:
>If you want a copy of the DATABASE and not of a table, I would suggest
>(using unix) ...
>
>cp -R /products here>/products1
Would this only be in the case when there was no activity on the
server? Would there be some possibility of conflict if some request
w
Hi!friend
I have tried many times to make mysql-3.23.39 on freebsd4.3.But it
always stopped at the same point(see the below).And I even tried make it on
different machines(Crixy MII¡¢PIII),it stopped at the same point.I even can
not install it by use ports or packages-add.Whats the matter??
Hi, My question is the following one: I have downloaded several times the file
mysql-3.23.39.tar.gz, I decompress using
shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -
and it always finishes with the following error: x
mysql-3.23.39/sql-bench/Results-win32/ATIS-access_odbc-win98-cmp-Access, my
I've been using a server called BigBiz for some years for several
different low-traffic websites. They offer a sandbox for developers
(so you have full CGI access) by somehow isolating each site from all
the others.
BigBiz offers Perl and PHP3 scripting, MySQL, a MajorDomo mailing
list and s
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Mon, Jul 09, 2001 at 09:29:00PM -0300, Rodney A. Ramos wrote:
>
> Is it possible to join two tables from different databases that are
> located on different hosts?
Nope.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454C
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
How are you updating in delphi and what is the error?
if you are running a query, setting the edit state and request live (either
at design or run time) and then updating the data and it complains that
someone else has changed the record then check the TQuery settings, there
is one that determ
I am searching for an ISP which has MySQL, any suggestions?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mai
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Dear MySQL developers and fanatics:
Alright, after lots of fiddling, I have more information for you. My previous fix (to
set LD_LIBRARY_PATH) DOES work. However, it has a shortcoming: users need to have
LD_LIBRARY_PATH set to use the mysql client and root needs to have LD_LIBRARY_PATH set
to
Hello,
I am running MySQL 3.23.37-log and I was looking at my .err log file. What I
found was a ton of entries like this one:
010709 16:35:01 Aborted connection 1040 to db: 'xsparts' user:
'xsparts_user' host: `localhost' (Got timeout reading communication packets)
Any idea what this means? How
Enhanced MySQL(tm) is as the words say a value-added version of
MySQL available from NuSphere and is available as part of two
products that contain NuSphere MySQL: NuSphere MySQL Advantage and
NuSphere Pro Advantage (which also includes a really nice PHP IDE if
you haven't seen it). Take a lo
Erich,
You need to create special "root" or "superuser" account so that you can connect
from your PC. This will allow you full access from DBtools. This is what I had
to do in order to make the connection. You'll need to log in as the 'root' or
'superuser' to execute your mysql client.
%>mysql g
> Is it possible to join two columns from different databases
Yes.
> located on differents hosts?
No. Why do you want to do this?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
If you want a copy of the DATABASE and not of a table, I would suggest
(using unix) ...
cp -R /products /products1
Where the datapath is the dir that contains all the databases.. in my setup
I usually make it /var/mysql... but often its in other places.
ryan
- Original Message -
From:
>Hi!
>
>My problem is when I use group by concat(col1,col2) when col1 and col2
>is primary keys and col1 is varchar(255):
>
>SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col2);
>-> return only one row - it is bad
>
>SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col1,col2);
>-> return 48 r
Does anyone know how to "allow" other hosts to connect to a MySQL database?
I have a pretty good GUI (DBTools) that will supposedly let you do this, but
whenever I try to connect to a MySQL Server that is not local, is says that
access is denied. I cant find it anywhere in Xinetd so I am assuming
> Right that's why I want to do a query which updates the picked field
> by setting it to 1 in 5000 random records where picked is null. Then I do
> a query to pull those 5000 out. Then I do a query to update picked to 0
> where picked = 1. So is there a way to update a random number of records
Table 1 and table 2 data values are the same accept some of the data in
table 2 was accidentally changed so I need to do an update to table 2
I need to update Table 2 values using Table 1 values based on the primary
key of table 2 equaling table 1 primary key.
Will This work
Update Table2 Set
Is it possible to join two columns from different databases located on
differents hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote:
> > We do a few large daily and monthly downloads from an Oracle database
> > server. Is there a way to exclude these specific queries from the
> > update/binary log??
>
> If the queries only affect one table or database, use the
> repli
http://www.mysql.com/udmsearch/search.php?q=UNION
finds 31 documents
Sie schrieben am Montag, 9. Juli 2001, 22:17:49:
> Hi,
> I wanted to take a union of two SQL queries for one of the front end
> screen. I searched help documents for "UNION" and did not find much. Do
> MySQL support "
> sorry im a mysql newbie...how do you bind mysql to two particular ip
> addresses? i have it bound to my loopback but would like to bind it a
> private ip but it doesn't seem to like the bind-address directive
> more than once.
Run two separate mysql daemons with a different --bind-address para
> We do a few large daily and monthly downloads from an Oracle database
> server. Is there a way to exclude these specific queries from the
> update/binary log??
If the queries only affect one table or database, use the replication ignore
options listed here: http://www.mysql.com/doc/R/e/Replicat
> Done, an email is now sent after an order is submitted. This is what it
> I have found a large number of files which have names like this
> www-bin.040
> www-bin.041
> www-bin.042
> www-bin.043
> www-bin.044
>
> which are using up huge amounts of disk space on my server.
>
>
Hi,
I am pretty new to mySql. (In fact just built a
databse and started working on it).
I want to do keyword search on a column (clob). It
may contain millions of records. How do I write query
so that it is efficient.
Thanks in advance for your time,
Puru.
__
On Mon, Jul 09, 2001 at 04:03:00PM -0500, Don Read wrote:
>
> On 08-Jul-01 Jeremy Zawodny wrote:
> > mytop - a `top' clone for MySQL
> >
> > http://public.yahoo.com/~jzawodn/mytop/
> >
>
> Thanks Jeremy, been using 0.5 (FreeBSD ports).
Oh, yeah. I forgot that someone made a port for it. Coo
On 08-Jul-01 Jeremy Zawodny wrote:
> mytop - a `top' clone for MySQL
>
> http://public.yahoo.com/~jzawodn/mytop/
>
Thanks Jeremy, been using 0.5 (FreeBSD ports).
I've got a couple of spare hours coming up, mind if i take
a whack at getting [mytop] into the my.cnf(s) files ?
Regards,
--
Don
On Monday 09 July 2001 10:51, Tibor Simko wrote:
> Hello
>
> On Tue, 19 Jun 2001, Sasha Pachev wrote:
>
> > If you have a spare development system, plug in 4.0 binary and try
> > to run your applications on it to see if it will crash.
>
> I just tried it on Debian GNU/Linux for i386 with up-to
We do a few large daily and monthly downloads from an Oracle database
server. Is there a way to exclude these specific queries from the
update/binary log??
-
Before posting, please check:
http://www.mysql.com/manual.php (
Hi,
I wanted to take a union of two SQL queries for one of the front end
screen. I searched help documents for "UNION" and did not find much. Do
MySQL support "UNION" SQL statement?
Thanks,
Nutan Pandit
Attronica Computers, Inc.
301-212-1355 (Ext 254)
--
I don't think this will work as you expect. You will have to mark
those that you picked from those you haven't picked (and marked)
before.
> SELECT * FROM 5600k WHERE picked IS NULL ORDER BY rand() LIMIT 5000;
> But what I really want to do is:
> UPDATE 5600k SET picked=1 WHERE picked IS NULL O
At 5:10 PM +0200 7/9/01, Werner Stuerenburg wrote:
>It's so easy, you won't think of it: start mysqld with parameter
>-h (=help):
>
>mysqld -h
>
>shows all parameters and current settings
Isn't that:
mysqladmin variables
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services |||
Title: Blank
I have found a large number of files which
have names like this
www-bin.040 www-bin.041
www-bin.042 www-bin.043
www-bin.044
which are using up huge amounts of disk
space on my server.
It looks to me like they are logs all of the
queries that are run with
At 6:41 PM +0200 7/9/01, Sascha Mantscheff wrote:
>Alas, it does not. It shows a couple of variable settings, but not the syntax
Something that may be of help are the sample .cnf files that are included in:
/usr/local/share/mysql/
(on my system at least)
Look for my-small.cnf, my-big.cnf, my-h
On 09-Jul-01 Daren Cotter wrote:
> I have two fields, sex, and age, which are both ENUM types. I'm building
> some statistical reports, using stuff like:
>
> DISTINCT(sex) ... GROUP BY sex ...
> and
> DISTINCT(age) ... GROUP BY age ...
>
> Now I want a report that shows me a breakdown by both c
I knew I would mess that up. yes, you are right, that's a much more elegant
solution.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: "Eugénio Veiga" <[EMAIL PROT
Cal Evans wrote:
> If both are using mySql, just use mysqldump to dump to a file and then
> import it from the file.
>
> It might be fun, just for grins and giggles to:
> mysqldump mysql newDatabaseName
That should be:
mysqladmin create newDatabaseName
mysqldump --opt databasename | mysql ne
I recently downloaded the latest MYSQL version 2.23.39a (from page
http://www.mysql.com/downloads/mysql-3.23.39a.zip), and installed it as
directed by the instructions:
* install directory: c:/mysql,
* datadir: c:/mysql/data,
* and created the config file: c:/my.cnf (see below
sorry im a mysql newbie...how do you bind mysql to two particular ip
addresses? i have it bound to my loopback but would like to bind it a
private ip but it doesn't seem to like the bind-address directive more than
once.
-
Befo
copy a table:
mysqldump database table_name > table.sql
or to copy the whole db:
mysqldump database > db.sql
- Original Message -
From: "Victor Spång Arthursson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 12:51 PM
Subject: Easiest way to create a duplicate o
Is there a way to update random records?
I have a database of 5.6 million records and I want to pull out 5000
records and mark a field in the database that I've pulled these so that I
don't pull the same 5000 again.
I know I can select the records by doing:
SELECT * FROM 5600k WHERE picked IS N
We saw a problem simlar to this caused by a browser add-on.
I believe flyswat was behind it, but it was that quickclick
browser add on that one of the tv networks is pushing.
Mike
On Wed, 4 Jul 2001 11:27:24 -0500
"Rob Donat" <[EMAIL PROTECTED]> wrote:
> Thanks for the note, I will determine i
mysqldump products >products.sql
grep s/products/products1/ < products.sql > products1.sql
mysql < products1.sql
Assuming that nothing else in the database is named products. (i.e. you
don't have any fields or tables named products) If you did have fields or
tables, you would most likely have to
If both are using mySql, just use mysqldump to dump to a file and then
import it from the file.
It might be fun, just for grins and giggles to:
mysqldump mysql newDatabaseName
and see if that works.
Obligatory warning: if you do this and it trashes your server and wrecks
your car, I was just ki
At 10:33 AM 7/9/01 +0200, Dominique Vellin wrote:
>We have made up our mind to turn our Access 2000 database into a MySGL one.
>Could you please explain us the path to follow and give us information about
>it ?
>
>Dominique Vellin
>Business developement
I don't know how much this will help, but I
mysqldump databasename | gzip > databasename.sql.gz
transfer that file to the other server
mysqladmin create databasename
zcat databasename.sql.gz | mysql databasename
> Hi
>
> Is it possible to import a complete database from a server to another
> one?
>
> Thanks
>
> Eugénio
--
For example if I want a copy of products named products1?
Sincerely Victor
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
I changed IP numbers on the Cobalt RAQ i have mysql on. I no longer have
access to the databases. I think i have lost access as root. Is there a
way to restore the root user password and/or change it to something else
manually? I have many websites with many 'access denied' errors.
Any help woul
Hi
Please visit the following link for the work around solution, else you can wait
till the next release version of the MyODBC.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?9:mss:10849:200106:lglmnlcggpoehpijkfol
Hope this helps you.
Best Regards
Venu Anuganti
Mateusz Rudyk wrote:
> Hi.
> I have
I have two fields, sex, and age, which are both ENUM types. I'm building
some statistical reports, using stuff like:
DISTINCT(sex) ... GROUP BY sex ...
and
DISTINCT(age) ... GROUP BY age ...
Now I want a report that shows me a breakdown by both categories, sex and
age...so I can see not just how
For example if I want a copy of products named products1?
Sincerely Victor
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
Easy as can be: for example
mysqld -O max_allowed_packet=2M
> Alas, it does not. It shows a couple of variable settings, but not the syntax
> for tha various logging options and the like. So the question for a complete
> options syntax of my.cnf remains open.
--
Herzlich
Werner Stuerenburg
Hi
Is it possible to import a complete database from a server to another
one?
Thanks
Eugénio
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arc
Hi everyone,
Replication has been working OK for me for the last month or
with mysql 3.23.38, however following a crash I am having a lot of problems.
This is happening constantly: replication will work for a while
and then stop with the following:
mysql> show slave status;
| Master_Host
Hello
On Tue, 19 Jun 2001, Sasha Pachev wrote:
> If you have a spare development system, plug in 4.0 binary and try
> to run your applications on it to see if it will crash.
I just tried it on Debian GNU/Linux for i386 with up-to-date "testing"
distro and up-to-date "bk clone". The compile pr
JJ> I need to create a table that have field names 'LEFT' and
JJ> 'RIGHT'. I have tried the following but it doesn't work:
JJ> [..skip..]
JJ> But nothing works. How should I do?
Rename 'left' and 'right' to something else. They are reserved words.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Hi Milos,
Thanks for responding!
I had updated the /etc/hosts files already, but went and checked it after
getting your message. Still no luck.
Any other troubleshooting clues?
Thanks!
Kurt Hansen
[EMAIL PROTECTED]
- Original Message -
From: Milos Rackov <[EMAIL PROTECTED]>
To: Kurt H
Ihre Nachricht vom Monday 09 July 2001 17:10:
> It's so easy, you won't think of it: start mysqld with parameter
> -h (=help):
>
> mysqld -h
>
> shows all parameters and current settings
Alas, it does not. It shows a couple of variable settings, but not the syntax
for tha various logging options
My Cobalt Raq4r was
recently rebooted by my co-lo ISP without contacting me
first.
Since mysql is not in the shutdown/startup
scripts on the server, it was crashed by the process.
Now when I start mysql normally, it does not
recognize any logins, even root and denies access unless
I start i
> I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the
>following but it doesn't work:
See http://www.mysql.com/doc/R/e/Reserved_words.html
Hint: use another laguage. In German, it is links and rechts for
left and richt.
--
Herzlich
Werner Stuerenburg
I experience heavy trouble with a few tables and look for the
cause for some time without finding out anything. I'm not ready
to construct a bug report, though.
Now I migrated these 3 tables from ISAM to MYISAM, so that I can
CHECK TABLE from within the program and do a REPAIR TABLE when
necessar
I had a similar problem recently. Try checking the /etc/hosts file to see if
the hosts/IPs are matching the current config.
Regards,
Milos Rackov
-Original Message-
From: Kurt Hansen [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 4:58 PM
To: [EMAIL PROTECTED]
Subject: ERROR 2013
i read somewhere that in version 4. or whatever one of the next versions
will be, that they are talking about doing the ability for bi-directional
replication. i have been trying to do the same thing
- Original Message -
From: Rolf Hopkins <[EMAIL PROTECTED]>
To: Simon Green <[EMAIL PRO
> 1. In which directory i can find the config file to config the log file
> 2. Where can i find the log file for mysql?
The log file will be in the data directory. In my case:
/usr/local/mysql/var
It has ending .err
You can place my.cnf in this dir also and some other places.
C
For Unix /etc/my.cnf
you then in the my.cnf say were you would like the logs!
Simon
-Original Message-
From: Krishna M [mailto:[EMAIL PROTECTED]]
Sent: 09 July 2001 16:27
To: [EMAIL PROTECTED]
Subject: Log files
Hello,
I have a Question,
1. In which directory i can fi
Bradley Jenkins wrote:
> i get this error when starting MySQL
>
> ERROR 2002: Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111)
>
> /var/lib/mysql/mysql.sock exists with srwxrwxrwx and user mysql.
I /var/lib/mysql at least mode 755?
>
> Brad.
>
>
> _
Thats a REALLY old version.
Jon Brookes wrote:
> Hi,
>
> I have been using mysql fine on a win32 box.. but have now also installed it on
>Linux box. The version details are below:
>
> Red Hat Linux release 6.0 (Hedwig)
> Kernel 2.2.5-15smp
>
> I am using this version of mySQL:
>
> mysqlad
Hi,
I need to create a table that have field names 'LEFT' and 'RIGHT'. I have tried the
following but it doesn't work:
CREATE TABLE WI_POSITION (
PICTUREFILE VARCHAR(200) NOT NULL,
PICFILEXT VARCHAR(5),
POSITIONNOVARCHAR(10) NOT NULL,
SEQUENCENOVARCHAR(3),
LEFT
Don't use the RPM in the 7.0 CD.
Roberto Carlos Sánchez Barroso wrote:
> If somebody could help to, this is the message that is shown in the
> /va//lib/mysql/[domain server name].err
>
> 010704 11:07:58 mysqld started
> 010704 11:07:58 /usr/libexec/mysqld: Table 'mysq
Hi!
My problem is when I use group by concat(col1,col2) when col1 and col2
is primary keys and col1 is varchar(255):
SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col2);
-> return only one row - it is bad
SELECT col1,col2 FROM Table1 GROUP BY concat(col1,col1,col2);
-> return 48 rows - it
Hello,
I have a Question,
1. In which directory i can find the config file to config the log file
2. Where can i find the log file for mysql?
regards,
\\|//
(@ @)
---oOO---(_)---OOo
)(
( Krishna Ma
Hello ,
I meet in share ver. of MySQL different lang. driver but no where
UKRAINIAN.
AND now I ask - I wont translete "errmsg.txt" and "errmsg.sys" for
UKRAINIAN lang?
Waiting for ansver!
--
Best regards,
suh mailto:[EMAIL PROTECTED]
-
You find a list of converters on page
http://www.mysql.com/downloads/contrib.html#SEC596
for example
dbf2mysql-1.14.tar.gz Convert between `.dbf' files and MySQL
tables
exportsql.txt A script that is similar to access_to_mysql.txt,
except that this one is fully configurable, has better type
con
Bonjour Matthieu,
I would also suggest installing MyODBC (from the downloads page).
The you can just use SQL to create and populate new tables by setting
up an database through ODBC.
En autre si tu as l'intérêt il y a une liste de MySQL francophone à :
S'abonner: [EMAIL PROTECTED]
Amicalem
Try looking for phpMyAdmin:
phpMyAdmin is intended to handle the
adminstration of MySQL over the web. Currently it can:
create and drop databases
create, copy, drop and alter tables
It's so easy, you won't think of it: start mysqld with parameter
-h (=help):
mysqld -h
shows all parameters and current settings
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 4
Ton Geurts wrote:
> Hi,
>
> I wonder I someone can give me some advice about the following situation. I
> have to install MySQL to be used with a website on a virtual server. This
> gives the following restraints:
>
> * MySQL must be installed in my user directory
> /usr/local/WWW/www.mydomain.
on 7/9/01 8:07 AM, Anoop K Gupta at [EMAIL PROTECTED] wrote:
> 2. mysql -h mydomainname -u root -p
>
> it prompts for password : it is blank so I just pressed enter. and Mysql
> prompt appeared..
if there is no password, you don't need the -p switch
-- mike cullerton
--
Hello,
I'm getting the error message above whenever I try to connect from a remote
host to a MySQL server. I issue the following command:
mysql --host=host_name -u user_name -ppass_word
and get the ERROR 2013 back as a response.
We have two servers, both running MySQL. I get the same message
Hi, Renaming of the database is on the TODO list. Some comments
follow.
1) Renaming of the directory will work for table types of MyISAM and
BDB (with exceptions). This won't work for InnoDB types.
2) When renaming a directory make sure to shutdown the server and that
you have no pending tran
You are going to have to write something to translate. I recently did a DBF
to MySQL migration. I wrote programs in Visual FoxPro to create .SQL files.
These files created the needed structure in MySQL and then did a butt-load
of insert's to populate the tables.
YMMV but it worked for me.
Cal
Cordialement,
We have made up our mind to turn our Access 2000 database into a MySGL one.
Could you please explain us the path to follow and give us information about
it ?
Dominique Vellin
Business developement
Azentis Technology
Your Outsourcing Provider
Tel : 33
1 - 100 of 143 matches
Mail list logo
