Hello Sabika,
On 12/4/2013 2:56 PM, Sabika Makhdoom wrote:
I would from 5.1.40 to 5.5.8 first and then to 5.6
Why 5.5.8? Our current release is 5.5.35. 5.5.8 is an ancient release
of 5.5 and represents the very first GA release of 5.5 . There have been
27 additional releases (each with the
I would from 5.1.40 to 5.5.8 first and then to 5.6
On Dec 4, 2013, at 11:33 AM, Ilya Kazakevich wrote:
> Hello,
>
> Have anybody tried to upgrade 5.1 to 5.6? I believe running mysql_upgrade
> should be enough, but does there are some caveats?
>
> Ilya Kazakevich.
--
MySQL General Mailing Li
On 2013-12-04 1:33 PM, Ilya Kazakevich wrote:
Hello,
Have anybody tried to upgrade 5.1 to 5.6? I believe running mysql_upgrade
should be enough, but does there are some caveats?
Ilya Kazakevich.
The MySQL recommendation is to upgrade one major version at a time, ie
5.1->5.5->5.6. There are s
Hello,
Have anybody tried to upgrade 5.1 to 5.6? I believe running mysql_upgrade
should be enough, but does there are some caveats?
Ilya Kazakevich.
- Original Message -
> From: "Sergei Petrunia"
>
> Create index on (importance, company_id) (or
> (company_id,importance), should
> not matter). When that index is present, the query should use ref
> access on it using both key parts (if by some crazy reason it doesn't, use
> FORCE
> IN
On Wed, Oct 19, 2011 at 05:09:13PM +1100, Wayne W wrote:
> Hi,
>
> I asked this question over on stackoverflow - basically I have a query
> and when using EXPLAIN I see that around 2400 rows are still being
> scanned. I'd added various indexes but it cannot make it perform any
> better.
>
> I wou
Hi,
I asked this question over on stackoverflow - basically I have a query
and when using EXPLAIN I see that around 2400 rows are still being
scanned. I'd added various indexes but it cannot make it perform any
better.
I would appreciate if anyone has any further ideas?
http://stackoverflow.com/
MuraliKrishna wrote:
Hi is it possible to have two instances of mysql over single windows xp.
because I want to workout with those as server and client. please help me
regarding this.
Sure you can!
Read this and get back to us with questions:
http://dev.mysql.com/doc/refman/5.1/en/multiple
Yes you can, but port has to be different.
Regards,
Thiyaghu CK
www.mafiree.com
On Sat, Feb 6, 2010 at 2:50 PM, MuraliKrishna <
murali_kris...@arthaoptions.com> wrote:
> Hi is it possible to have two instances of mysql over single windows xp.
> because I want to workout with those a
Hi is it possible to have two instances of mysql over single windows xp.
because I want to workout with those as server and client. please help me
regarding this.
c...@hosting4days.com wrote:
:Newbie:
Short Question: Is it possible to create an inner join (or another join)
with multiple tables?
something like
$query_list1 = "SELECT table1.id,table1.status, table2.id, table3.id
(more here - etc.) FROM table1
INNER JOIN table2 ON table1.id = tabl
I don't see why not, but another choice is to create a view that encompasses
all these tables and Select * From my_view.
Arthur
On Fri, Sep 25, 2009 at 11:28 PM, c...@hosting4days.com <
c...@hosting4days.com> wrote:
> :Newbie:
> Short Question: Is it possible to create an inner
:Newbie:
Short Question: Is it possible to create an inner join (or another
join) with multiple tables?
something like
$query_list1 = "SELECT table1.id,table1.status, table2.id, table3.id
(more here - etc.) FROM table1
INNER JOIN table2 ON table1.id = table2.id
INNER JOIN table3 ON t
I have a column which contains a list of IDs separated by commas. How
can I take the content of this column, and insert it into a temporary
table so that each ID is on a separate row? Can this be done using
SQL?
Can be done in a stored procedure, or (more easily) in an application
language.
I have a column which contains a list of IDs separated by commas. How
can I take the content of this column, and insert it into a temporary
table so that each ID is on a separate row? Can this be done using
SQL?
Thanks!
Khai
--
MySQL General Mailing List
For list archives: http://lists.mysql.
Richard,
>1) If a user has never logged in he doesn't show the user in the list
>2) It doesn't count if it is 0 it's not on the liste and if the user
has logged
>in more than once the result is 1 (because of the group by ...).
Do you mean by #1 that you want to list all users whether they hav
Try this one:
SELECT a.username, a.first_name,
a.last_name,COALESCE(COUNT(b.username), 0) AS count
FROM user_list a
LEFT JOIN login_table b ON a.username = b.username
GROUP BY a.username,a.first_name,a.lastname;
The LEFT JOIN will ensure you still get a result row even if there are
no match
ect
Re: group a select * and a select COUNT from 2 different tables using
result of first table to do the COUNT ... is it possible ?
Sorry it's me again, I made a mistake, it counts the number of logins
correctly, but does not show members with 0 logins !
Any idea how to do th
PM
To
[EMAIL PROTECTED], mysql@lists.mysql.com
cc
Subject
Re: group a select * and a select COUNT from 2 different tables using
result of first table to do the COUNT ... is it possible ?
Sorry it's me again, I made a mistake, it counts the number of logins
correctly, but does not s
Sorry it's me again, I made a mistake, it counts the number of logins
correctly, but does not show members with 0 logins !
Any idea how to do this?
Thanks :)
Peter Brawley a écrit :
Richard,
>Can I do something like this :
>SELECT a.username, a.first_name, a.last_name,b.(SELECT COUNT(*) AS
Hi, and thankyou for trying to help me out! I've tried this and it does
not work. Here are the problems :
1) If a user has never logged in he doesn't show the user in the list
2) It doesn't count if it is 0 it's not on the liste and if the user
has logged in more than once the result is 1 (bec
Richard,
>Can I do something like this :
>SELECT a.username, a.first_name, a.last_name,b.(SELECT COUNT(*) AS count
>FROM login_table b WHERE a.username = b.username) FROM user_list a
Try ...
SELECT a.username, a.first_name, a.last_name,COUNT(b.username) AS count
FROM user_list a
JOIN login_tabl
Hello,
This time I'm rearly not sure if this is possible to do. I've got two
queries that I would like to bring together to make only one query ...
I've got a list of users
And also a login table
I would like to list all users and show the number of times they have
logged in.
So to get th
: Is it possible to either update or insert in a single query?
This part of the manual might be of use to you:
REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name [(col_name,...)]
VALUES ({expr | DEFAULT},...),(...),...
Or:
REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name
SET
AM
To: [EMAIL PROTECTED]
Subject: Is it possible to either update or insert in a single query?
Apologies if this is a dumb question, but is it possible to write a
single
query that either updates certain columns in a row, or adds an entirely
new
row if there is none already?
I seem to be running
> REPLACE is a MySQL extension to the SQL standard. It either inserts, or
> deletes and inserts. For another MySQL extension to standard SQL — that
> either inserts or updates — see Section 13.2.4.3, “INSERT ... ON DUPLICATE
> KEY UPDATE Syntax”.
Take note!!
If you're using triggers, foreign key
s a dumb question, but is it possible to write a single
> query that either updates certain columns in a row, or adds an entirely
> new
> row if there is none already?
>
> I seem to be running into this a lot, and so far I've solved it by:
> 1) run UPDATE table SET x,y WHERE so
Have you look at replace ?
http://dev.mysql.com/doc/refman/5.0/en/replace.html
Carlos
Douglas Pearson wrote:
Apologies if this is a dumb question, but is it possible to write a single
query that either updates certain columns in a row, or adds an entirely new
row if there is none already?
I
Apologies if this is a dumb question, but is it possible to write a single
query that either updates certain columns in a row, or adds an entirely new
row if there is none already?
I seem to be running into this a lot, and so far I've solved it by:
1) run UPDATE table SET x,y WHERE some row
In the last episode (Jul 19), Cheng-Lin Yang said:
> I'd like to know if it's possbile to make MySQL auth the account
> through system account via NIS? I want the user in my system who can
> automatically have their own mysql account by using the same password
> on the system. Please kindly help me
I'm far from an expert on the subject, but judging by a quick Google
search for 'NIS mysql backend', people have been able to do this via
OpenLDAP. I just thought I'd send you a starting point.
On 7/19/06, Cheng-Lin Yang <[EMAIL PROTECTED]> wrote:
Hi all,
I'd like to know if it's possbile to ma
Hi all,
I'd like to know if it's possbile to make MySQL auth the account
through system account via NIS? I want the user in my system
who can automatically have their own mysql account by using
the same password on the system. Please kindly help me on this
problem. Thank you in advanced! :)
Regard
Hi all,
I'm trying to figure out how much space would be necessary for the mysqldump
with the -opt option.. The inodb tablespace is using roughly 130 G, plus maybe
5 G for various myisam files.
Is it possible to get even a rough estimate?
Thanks in advance.
--
MySQL General Mailing
Hello Vaidas,
Monday, May 9, 2005, 3:08:26 PM, you wrote:
hm founded something intresting :)
set @mynr:=0;
Select @mynr as nr,table.id from table
where @a:=IF((table.id=0),0,(@a+1)) having table.id=518 order by id
strange IF hack :)
main problem what this metod not fast. tested in table with 35
Hello Roger,
Monday, May 9, 2005, 2:56:18 PM, you wrote:
Heh if i know page i would haven't problem.
but i need to get also correct page with link
doomain.con/items.php?showid=45
it can be anywhere! :)
I making web application with data binding (IE stuff) data is loading
very fast, can be 10
Vaidas Zilionis wrote:
[...]
Example items are displayed 100 in page, and i display 20 pages
numbers
1 ... 4[5] 6 x
doomain.con/items.php?page=5
and i get all result here with limit 400,100
Yes, with PHP it would be something like this:
$items_per_page = 100;
$limit_clause = ((int)$page-1)*$ite
Hi all,
let's figure we have one big database table ~1mln rows.
I can easly to collect needed data from this table with query:
SELECT id,title,cdate FROM bigtable WHERE active ORDER BY cdate ASC,
id ASC LIMIT 300,100
So i get needed rows to display.
i can make easly with page numbers to display
Not sure if your query works. But what should work is
SELECT * FROM table WHERE c LIKE "%word1%" and c LIKE "%word2%" and c LIKE
"%word3%";
But might be slow ...
Am Thursday 14 April 2005 13:53 schrieb Micha Berdichevsky:
> Hi group.
> I have a table with a varchar(250) column in it (let's call
;
To: mysql@lists.mysql.com
Subject: LIKE question - is it possible?
Date: Thu, 14 Apr 2005 13:53:31 +0200
Hi group.
I have a table with a varchar(250) column in it (let's call it c)
I want to select values that contain a number of given words in them (three
or more), in any words order
I currentl
Micha Berdichevsky <[EMAIL PROTECTED]> wrote on 14/04/2005 12:53:31:
> Hi group.
> I have a table with a varchar(250) column in it (let's call it c)
> I want to select values that contain a number of given words in them
> (three or more), in any words order
> I currently use
> SELECT * FROM table
Hi group.
I have a table with a varchar(250) column in it (let's call it c)
I want to select values that contain a number of given words in them
(three or more), in any words order
I currently use
SELECT * FROM table WHERE c LIKE "%word1%word2%word3%";
I was wandering if it is possible to use a qu
I am using SELECT statements to write some files via INTO OUTFILE. This has
been working fine, but now I have the need to export the column headings
from the MySQL tables along with the column contents. Is this possible? If
so, how?
Ex.
SELECT stock, vin, color, mileage, price, cylinders, p
zzapper <[EMAIL PROTECTED]> wrote:
> Is it possible to have undeletable/unmodifiable records in a table of otherwise
> modifiable &
> deleteable & createable records?
>
> At present I do it at the Update/Delete level where I have clauses which prevent
> ce
delete or
modify those otherwise permanent records.
Wes
On Fri, 03 Sep 2004 11:38:35 +0100, zzapper <[EMAIL PROTECTED]> wrote:
Hi Y'All
Is it possible to have undeletable/unmodifiable records in a table of otherwise
modifiable &
deleteable & createable records?
At present
otherwise permanent records.
Wes
On Fri, 03 Sep 2004 11:38:35 +0100, zzapper <[EMAIL PROTECTED]> wrote:
> Hi Y'All
>
> Is it possible to have undeletable/unmodifiable records in a table of otherwise
> modifiable &
> deleteable & createable records?
>
> A
Hi Y'All
Is it possible to have undeletable/unmodifiable records in a table of otherwise
modifiable &
deleteable & createable records?
At present I do it at the Update/Delete level where I have clauses which prevent
certain records
being changed. I suppose I could also have an
Best,
Yoed
-Original Message-
From: Greg Hosler [mailto:[EMAIL PROTECTED]
Sent: Friday, April 23, 2004 7:08 PM
To: [EMAIL PROTECTED]
Subject: Is it possible to get a timestamp from the server ?
Hi,
I have a database application that I am porting to MySQL. one of the things
that the a
D]
Subject: Is it possible to get a timestamp from the server ?
Hi,
I have a database application that I am porting to MySQL. one of the
things that the application needs to do is to get a timestamp from the
server, so that all instances of the application across a network can
timestamp cewrta
Hi,
I have a database application that I am porting to MySQL. one of the things
that the application needs to do is to get a timestamp from the server, so that
all instances of the application across a network can timestamp cewrtain
records using a common source for the timestamp. e.g. the sql ser
Boy do I feel dumb. :^)
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Monday, February 09, 2004 4:54 PM
To: [EMAIL PROTECTED]
Subject: RE: is it possible...
UPDATE EMAIL_TEST_LIST SET EMAIL_DATE = curdate();
-Original Message-
From: Ligaya Turmelle [mailto
UPDATE EMAIL_TEST_LIST SET EMAIL_DATE = curdate();
-Original Message-
From: Ligaya Turmelle [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 10:42 PM
To: [EMAIL PROTECTED]
Subject: is it possible...
Is it possible to have an update statement that uses curdate()?
Example
Is it possible to have an update statement that uses curdate()?
Example:
UPDATE EMAIL_TEST_LIST SET EMAIL_DATE = "(SELECT curdate())";
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
called "members". One of the fields in this database
is "user_name". There are a number of records in
this database. Under the field user_name, I would
like to make some changes manually; for example, I
want to change
John Doe
to
john_doe
Is it possibl
ROTECTED]>
Sent: Thursday, December 18, 2003 11:28 AM
Subject: Re: Is It Possible To Change the Value of A Particular Field
Manually?
>
> Caroline Jen wrote:
> > Hi, I am not a database person. I have a database
> > called "members". One of the fields in this databa
want to change
John Doe
to
john_doe
Is it possible to do it? How do I do it? Thank you
very much in advance.
Yes. You can specify the records you want with a WHERE clause. First
try a SELECT to test your WHERE clause to make sure you get just the
record(s) you want:
SELECT * FROM mem
nge
John Doe
to
john_doe
Is it possible to do it? How do I do it? Thank you
very much in advance.
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
--
MySQL General Mailing List
For list archives: http://list
Eugene R. Miller wrote:
This is kind of a silly question is there an easy way to ...
SELECT Status, rating, COUNT(*) FROM song GROUP BY pldupldqd, rating ORDER BY
Status, rating DESC
This gives me all the information I need ...
What I would like to do is something... like
SELECT rating, count(
This is kind of a silly question is there an easy way to ...
SELECT Status, rating, COUNT(*) FROM song GROUP BY pldupldqd, rating ORDER BY
Status, rating DESC
This gives me all the information I need ...
What I would like to do is something... like
SELECT rating, count(WHERE pldupldqd = 0), co
Try taking out the identifier name for the primary key (pk_foo). The
way I read the documentation, MySQL does not support identifiers or
names for primary keys although it does for other index types.
HTH
Randy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
I did the following (not much different):
CREATE TABLE `foo` (
`pri_1` INT UNSIGNED NOT NULL,
`pri_2` INT UNSIGNED NOT NULL,
`pri_3` INT UNSIGNED NOT NULL,
`test_data` VARCHAR(120) NOT NULL,
PRIMARY KEY (`pri_1`, `pri_2`, `pri_3`)
) TYPE = InnoDB;
Regards,
Ritter
--
Jason k Larson
Fortun
All,
I've got an InnoDb table that requires a composit key constraint. However,
I'm not certain how to word the DDL syntax.
Pretending for a sec this was SQL Server 2000 or Sybase ASE 12.5 I'd use the
following.
CREATE TABLE foo(
pri_1 INTEGER NOT NULL,
pri_2 INTEGER NOT NULL,
pri_3 INTEGER
KINS E-mailHi all,
I plan to make SQL queries in different threads(pthread) maked with mysql C API.
Can I use the same Connection object in all threads for the queries ?
Or should I use a different Connection object for each thread ?
p.s If it is possible, let me get some example code.
At 21:26 -0400 9/3/03, Dan Anderson wrote:
I'm writing a search engine to query a database to my site. I know how
to use a WHERE product_name = "foo" if somebody enters the exact product
name, but how could I do something like: WHERE product_name = "*foo*" so
all results containing "foo" in produc
I'm writing a search engine to query a database to my site. I know how
to use a WHERE product_name = "foo" if somebody enters the exact product
name, but how could I do something like: WHERE product_name = "*foo*" so
all results containing "foo" in product name would be returned and not
just produ
x27;s unattended desk. Most security chains can be cut with a small
pair of bolt cutters. I have to convince my boss that if the laptop
disappears it won't put the company out of business, and me out of a job.
Is it possible to secure the MySQL database on the laptop so if it does get
stolen, the i
.
Cheers
/rudy
-Original Message-
From: Dan Anderson [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 16:49
To: [EMAIL PROTECTED]
Subject: Is it possible to dump images into a database?
Can anyone point me to a reference on how to insert images into a column
in a mySQL database -- or is
Yes it is. If you are using VB look at
www.vbmysql.com/articles/blobaccessvb.html
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Dan Anderson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 09, 2003 8:49 AM
> To: [EMAIL PROTECTED]
> Subject: Is it p
take a look at:
http://www.php4.com/forums/viewtopic.php?t=6
or search the mailing list archive.. there are plenty of threads talking
about this:
For list archives: http://lists.mysql.com/mysql
On Wed, 9 Jul 2003, Dan Anderson wrote:
> Can anyone point me to a reference on how to insert ima
Can anyone point me to a reference on how to insert images into a column
in a mySQL database -- or is that not possible?
Thanks in advance,
Dan Anderson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
check out http://www.phpbuilder.com
thay have a lot of things and that is one off them.
--
eschew obfuscation.
-Original Message-
From: Digital Directory USA [mailto:[EMAIL PROTECTED]
Sent: 29 June 2003 19:28
To: [EMAIL PROTECTED]
Subject: inserting images to mysql - is it possible?
I
PROTECTED]>
Sent: Monday, June 30, 2003 7:35 AM
Subject: Re: inserting images to mysql - is it possible?
> Armand-
>
> Why is it not recommended to store images in a database? I've not heard
this...
>
>
> bob.
>
>
>
> At 09:51 PM 6/29/03 +0200, you wrote:
>
Sent: Monday, June 30, 2003 7:35 AM
Subject: Re: inserting images to mysql - is it possible?
> Armand-
>
> Why is it not recommended to store images in a database? I've not heard
this...
>
>
> bob.
>
>
>
> At 09:51 PM 6/29/03 +0200, you wrote:
> >Hi,
> >
Armand-
Why is it not recommended to store images in a database? I've not heard this...
bob.
At 09:51 PM 6/29/03 +0200, you wrote:
Hi,
You have to insert a new blob field where you can store binary data. But
it is not recommanded to store images in a database. I recommande you to
store image
If you want to store images in the database, use a blob columntype.. And
take a look at this example alot of people have based mysql binary
storage off: http://www.php4.com/forums/viewtopic.php?t=6
good luck
On Sun, 29 Jun 2003, Digital Directory USA wrote:
> I am new to php and mysql, I have
Hi,
You have to insert a new blob field where you can store binary data. But
it is not recommanded to store images in a database. I recommande you to
store images on a server filesystem and only the reference to the
images in a database.
Armand
Digital Directory USA wrote:
I am new to php an
I am new to php and mysql, I have searched looked over and cannot find a way to do
this... can it be done?
I have set up the following in mysql. How do I upload the product images to the pPhoto
column. Any suggestions?
ds_produc
Field Type Attributes Null Default Extra
pID
On Fri, 2003-06-20 at 12:16, Barbara Andrew wrote:
> I have three books on mySQL, they all talk about how to
> construct SQL statements and I'm fine with that. What I can't figure out is
> how to get those statements to the right place without having to do it
> manually.
This would be the domai
Hi there,
I'm just getting started with mySQL and PHP. I've used phpMyAdmin to create
tables and insert data into them from a delimited text file. From there I'm
creating a web page to view the data. Ideally this table would be refreshed
every night as it is a data dump from our production server.
udlik
> Becoming Digital
> www.becomingdigital.com
>
>
> - Original Message -
> From: "Martin Waite" <[EMAIL PROTECTED]>
> To: "MySQL List" <[EMAIL PROTECTED]>
> Sent: Monday, 09 June, 2003 04:45
> Subject: is it possible to get around 4 bil
09 June, 2003 04:45
Subject: is it possible to get around 4 billion row limit
Hi,
I want to create a table with a lot (8 billion)
small fixed-length records.
I thought setting MAX_ROWS in the create table
would do this for me, but it looks like it quietly
ignores values over 4.2 billion.
Is t
ng systems only supports 2G tables)."
http://www.mysql.com/doc/en/CREATE_TABLE.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Martin Waite" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, 09
Hi,
I want to create a table with a lot (8 billion)
small fixed-length records.
I thought setting MAX_ROWS in the create table
would do this for me, but it looks like it quietly
ignores values over 4.2 billion.
Is this a hard-limit in MySQL ?
Does MySQL 4.0.x have the same limitation ?
(MySQL
t; Sent: Thursday, April 03, 2003 5:10 PM
> To: [EMAIL PROTECTED]
> Subject: self foreign keys and InnoDB is it possible ?
>
>
> hi all
>
> I'm creating a table like this
>
> CREATE TABLE test (
> id integer not null primary key auto_increment,
>
hi all
I'm creating a table like this
CREATE TABLE test (
id integer not null primary key auto_increment,
testchar(20),
father integer key default ='-1' not null,
FOREIGN KEY (id) RERERENCES test(padre) ON DELETE CASCADE
) Type=InnoDB;
But I made some mi
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
> Why do you want to store the sum of columns? You can just sum them when
> you retrieve data.
The database has got about 1 million records, and it gorws day by day
The query I need returns lots of records, and calculating it while
retrieving data
On Thursday 20 March 2003 21:10, Juan Nin wrote:
> Imagine I have a table with 3 colums (column1, column2, column3), which are
> of type INT.
>
> I want the data in column3 to be generated automatically from the one in
> column1 and column2 when it is inserted
> For example a sum, that the data in
Hi, I got the following question:
Imagine I have a table with 3 colums (column1, column2, column3), which are
of type INT.
I want the data in column3 to be generated automatically from the one in
column1 and column2 when it is inserted
For example a sum, that the data in column3 be the sum of col
Hi all,
Sorry to bother the list, since I'm pretty sure the answer is no, but
I'm trying to figure out if it's possible to prevent a user from
dropping some tables in a database while allowing him/her to drop
others. I've seen requests on the list for something similar, but not
a solution.
Sp
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> I can FTP and telnet in to my site as "admin" or a user, but
> all the files in
> /var are owned by root so cannot be deleted, with the
> exception of several
> mysql files owned by mysql, which I also cannot
I can FTP and telnet in to my site as "admin" or a user, but all the files in
/var are owned by root so cannot be deleted, with the exception of several
mysql files owned by mysql, which I also cannot move or delete :( If I could
extract the info in the database I could delete that remotely, t
on 12/19/2002 5:00 PM, Paul Nolan at [EMAIL PROTECTED] wrote:
> I`ve got myself into a bit of a mess by allowing my raq3's 200mb var partition
> to fill up. This means I can no longer login to my server as root, because a
> log file of my login cannot be created. Naturally only root can delete o
Hello,
I`ve got myself into a bit of a mess by allowing my raq3's 200mb var partition
to fill up. This means I can no longer login to my server as root, because a
log file of my login cannot be created. Naturally only root can delete or
move any files in /var to fix this problem :o Anyway, t
Dear Steve,
> Is it possible to export data from MS Access into MySQL?
If you don't care to export every single table manually, this is what
you do:
1. Install MyODBC 3.51.04
2. Configure a system DSN for your MySQL server.
3. In Access, right-click the table to be exported.
4. Choos
r 26, 2002 12:50 PM
To: MySQL General Mailing list; [EMAIL PROTECTED]
Subject: Re: Is it possible to export data from access to MySQL?
you're gonna get lots of neat high tech answers
to your problem, so here's a low tech answer just
because it's fun.
construct the database i
a and copy the data. open
the mysql table a and paste the data.
: ) the kid in me loves doing that. copy and
paste is the most powerful concept in windows.
the only reason that i don't use it in corereader
is that it would permanently tie corereader into
ms. windows.
> Is it possi
[EMAIL PROTECTED]> 11/26/02 6:37:45
AM >>>
Is it possible to export data from MS Access into MySQL?
If so how?
I have a huge amount of data that will take weeks to input and I've
convinced my boss to use MySQL rather than any other DB because of
it's
compatibility with PHP.
a
On Tue, 26 Nov 2002, Steve Jackson wrote:
> Is it possible to export data from MS Access into MySQL?
> If so how?
> I have a huge amount of data that will take weeks to input and I've
> convinced my boss to use MySQL rather than any other DB because of it's
> com
em for a day. If
you
teach them how to program, you will frustrate them for a lifetime."
-Original Message-
From: Steve Jackson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 9:38 AM
To: MySQL General Mailing list
Subject: Is it possible to export data from access to M
MySQL-Front is quite good for this...
- Original Message -
From: "Steve Jackson" <[EMAIL PROTECTED]>
To: "MySQL General Mailing list" <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 4:37 PM
Subject: Is it possible to export data from access to MyS
age-
> From: FlashGuy [mailto:[EMAIL PROTECTED]]
> Sent: 26. marraskuuta 2002 16:42
> To: MySQL General Mailing list; [EMAIL PROTECTED]
> Subject: Re: Is it possible to export data from access to MySQL?
>
>
>
> Download MySQL-Font v2.5
>
> This is what I used whe
1 - 100 of 146 matches
Mail list logo
