our database is about 20 Gb and growing daily. so far, I still see
nearly constant time query performance on tables with ~10M rows. I
don't think mysql is limited by file size per se.
I guess performance depends a lot on what your tables look like, and
your hardware, obviously. From my own
On Thu, Nov 06, 2003 at 05:08:54PM -0700, Jeff Mathis wrote:
our database is about 20 Gb and growing daily. so far, I still see
nearly constant time query performance on tables with ~10M rows. I don't
think mysql is limited by file size per se.
It is limited to the extent that your operating
We're talking about storing binary files (images) inside a MySQL database
to take advantage of the granularity and control we get over file access
that way.
But we already have 1.5GB, and that could lead to a very large database
very quickly.
What are people's experiences with large MySQL
our database is about 20 Gb and growing daily. so far, I still see
nearly constant time query performance on tables with ~10M rows. I don't
think mysql is limited by file size per se.
Ari Davidow wrote:
We're talking about storing binary files (images) inside a MySQL database
to take
Greetings,
I have a datafile called 'salary.txt', and it's a tab delimited file, the
structure is like this:
employee_nametabsalaryenter
employee_nametabsalaryenter
...
I have a table called 'salary', and it has the same structure as the
'salary.txt' --- employee_name salary as the columns;
I
Greetings,
I have a datafile called 'salary.txt', and it's a tab delimited file, the
structure is like this:
employee_nametabsalaryenter
employee_nametabsalaryenter
...
I have a table called 'salary', and it has the same structure as the
'salary.txt' --- employee_name salary as the columns;
I
backup tool for MySQL
- Original Message -
From: Rob Kings [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 25, 2003 2:20 PM
Subject: Re: Move a MySQL Database to another system
spyros
Well I just did pretty much the opposite. From Linux to XP. Take
Paul DuBois wrote:
At 5:24 PM +0200 9/13/03, karim bernardet wrote:
[EMAIL PROTECTED] wrote:
From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like
[EMAIL PROTECTED] wrote:
From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like mysqldump --tab or mysql -e
SELECT ... outfile to generate the file
At 5:24 PM +0200 9/13/03, karim bernardet wrote:
[EMAIL PROTECTED] wrote:
From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like mysqldump --tab or
Hello,
Is it possible to retrieve a file stored in a blob field using a mysql
client from a host which is not the server ?
Thanks for your help,
Karim.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From mysql manual:
If you want to create the resulting file on some other host than the
server host, you can't use SELECT ... INTO OUTFILE. In this case you
should instead use some client program like mysqldump --tab or mysql -e
SELECT ... outfile to generate the file
On Fri, 12 Sep 2003,
-Original Message-
From: Watter [mailto:[EMAIL PROTECTED]
Sent: den 10 september 2003 17:45
To: [EMAIL PROTECTED]
Subject: MySQL database help
Dear Sir,
I know your email add. from mysql.com.
If you know how to solve this problem, please teach me. your
reply
Check your ownerships and permissions.
On Thu, 21 Aug 2003 00:27:05 +0800, Jon Miller used a
few recycled electrons to form:
| I've tried moving the database from one partition to another and now I'm getting the
following error:
| # Starting mysqld daemon with databases from /data/mysql
|
I've tried moving the database from one partition to another and now I'm getting the
following error:
# Starting mysqld daemon with databases from /data/mysql
030820 23:48:08 mysqld ended
When I issue #/ /usr/share/mysql/mysql.server start
Anyone have any idea what's gone wrong. I changed the
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.g
Is it possible to secure the MySQL database on the laptop so if it does get
stolen, the information
into MySQL database server ? Please help me,
thank you in advance. The following is my table and SQL code.
CREATE TABLE GAME (
GAME_ID INTEGER NOT NULL PRIMARY KEY,
GAME_NAMEVARCHAR (20),
VIDEO LONGBLOB
);
INSERT INTO GAME GAME_ID
function. Does anyone know how to store video into MySQL
database server ? Please help me,
thank you in advance. The following is my table and SQL code.
You've told us what you've tried, but you didn't tell us what happened?
Did you get an error message? If so, what was it?
CREATE TABLE GAME
into the cooresponding field of a table by using the LOAD_FILE function. Does anyone know how to store video into MySQL database server ? Please help me,
thank you in advance. The following is my table and SQL code.
CREATE TABLE GAME (
GAME_ID INTEGER NOT NULL PRIMARY KEY,
GAME_NAME
On Tue, Jul 22, 2003 at 12:03:44PM -0700, Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file. The
format of video is either avi or mpg. However I can not successfully
insert the video file into the cooresponding field of a table by
using
PROTECTED]
Sent: Tuesday, July 22, 2003 12:12 PM
Subject: Re: store video file into MySQL database server
On Tue, Jul 22, 2003 at 12:03:44PM -0700, Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file. The
format of video is either avi
not successfully insert the
video file into the cooresponding field of a table by using the LOAD_FILE
function. Does anyone know how to store video into MySQL database server ? Please
help me,
thank you in advance. The following is my table and SQL code.
CREATE TABLE GAME (
GAME_ID
:12 PM
Subject: Re: store video file into MySQL database server
On Tue, Jul 22, 2003 at 12:03:44PM -0700, Steven Wu wrote:
Hi Need emergency help:
I am doing some project use the MySQL to store the video file. The
format of video is either avi or mpg. However I can not successfully
, July 22, 2003 2:04 PM
To: [EMAIL PROTECTED]
Subject: store video file into MySQL database server
Hi Need emergency help:
I am doing some project use the MySQL to store the video file.
The format of video is either avi or mpg. However I can not successfully
insert the
video file
luck,
Jef
-Original Message-
From: Dan Anderson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 4:31 PM
To: Partap Davis
Cc: [EMAIL PROTECTED]
Subject: Re: How can I display images from a mySQL Database in a web
page?
I think there is a way to insert binary image data
Dan Anderson wrote:
I have created a BLOB field to store images. Is there any way to embed
them within HTML with something like:
I've done some notes on this at
http://www.scit.wlv.ac.uk/~jphb/sst/php/extra/images1.html
- assuming of course you're using PHP as a WWW backend to
dig the stuff
image start: jpeg
/image
use this:
echo 'img src='.mysql_result($conn, 0, 0).' alt=';
where 0,0 is the result-set index for your mysql field. you might
use other mysql functions of course, but the place to put the output
in is the same
the html-source code will look like it is
I have created a BLOB field to store images. Is there any way to embed
them within HTML with something like:
image start: jpeg
/image
Thanks in advance,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
THis is kinda offtopic.. it depends on what frontend you are using to
access mysql (php,java,perl,etc) ..
You just need to pull the binary data and output it with the correct http
headers and it will show up in a browser.. search the list for more
info. www.php4.com has an example using php..
I think there is a way to insert binary image data in your html, but is
there any particular reason you need to do that?
First you would need to encode it in some ascii equivalent (check w3c.org, I
think) ...and it would increase the size of your html page while rendering
the browser's image
I think there is a way to insert binary image data in your html, but is
there any particular reason you need to do that?
First you would need to encode it in some ascii equivalent (check
w3c.org, I think) ...and it would increase the size of your html page
while rendering the browser's image
I think there is a way to insert binary image data in your html, but is
there any particular reason you need to do that?
Yes, my client's server is running with particularly restrictive PHP
safe mode settings and has informed me that dynamic images are a /must
have/. :: bangs head against
On 15 Jul 2003 at 18:31, Dan Anderson wrote:
I think there is a way to insert binary image data in your html, but
is there any particular reason you need to do that?
Yes, my client's server is running with particularly restrictive PHP
safe mode settings and has informed me that dynamic
I have a MySQL Server in a Windows Box. How can I connect to the server
from another windows box using ODBC?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
http://www.mysql.com/products/myodbc/index.html
-Original Message-
From: Azrin Aris [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 12:15
To: [EMAIL PROTECTED]
Subject: How to connect o remote MySQL Database
I have a MySQL Server in a Windows Box. How can I connect to the server
have you done any optimize to your tables ?
it should help improving the query performance.
it's normal to have memory lower on each day, because your index files are growing,
and takes memory.
if you're not using innodb or bdb, you can try to run flush threads and flush
tables. it might
At 14:35 -0700 7/8/03, Steve Quezadas wrote:
have you done any optimize to your tables ?
it should help improving the query performance.
it's normal to have memory lower on each day, because your index
files are growing, and takes memory.
if you're not using innodb or bdb, you can try to
HIdey Ho.
I have a fairly large mysql database (a few million records) and queries run pretty
damn fast. However, over time (say, over the course of a month), performance gets
slower and slower. I am not sure why! I suspected a memory leak so i restarted mysql.
No dice. Now, if I reboot
lol of course
mysqldump -u username -p databasename databasename.sql
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 3:08 PM
To: [EMAIL PROTECTED]
Subject: mysql database dump
Can I dump a database while the database is running in mysql
At 1:08 -0400 6/28/03, Asif Iqbal wrote:
Can I dump a database while the database is running in mysql ?
Yes. You can, for example, use the mysqldump program. mysqldump
is a MySQL client program that, like all MySQL clients, requires
the server to be running.
--
Asif Iqbal
On Sat, Jun 28, 2003 at 06:14:07PM +1000, electroteque wrote:
lol of course
mysqldump -u username -p databasename databasename.sql
I am atempting to backup a database remotely. I added something like the
following.
mysql GRANT ALL PRIVILEGES ON db.*
- TO
On Sat, Jun 28, 2003 at 11:35:54AM -0600, Jerry M. Howell II wrote:
On Sat, Jun 28, 2003 at 06:14:07PM +1000, electroteque wrote:
lol of course
mysqldump -u username -p databasename databasename.sql
I am atempting to backup a database remotely. I added something like the
following.
Can I dump a database while the database is running in mysql ?
--
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08
There's no place like 127.0.0.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Write a quick perl program.
O.S. Bos wrote:
Hi there,
I have a textfile that I want to get inserted into a database. The
textfile consists of Questions and Answers. 1st line is a question. 2nd
line of the textfile is the answer. And so on...
What is the best way to import these lines into the
, is that if you have any wierd characters, they
arent escaped.
or you could just write a perl program
chris
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 8:21 AM
To: O.S. Bos
Cc: [EMAIL PROTECTED]
Subject: Re: Textfile to a 2 column mysql database
Write
[mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 8:21 AM
To: O.S. Bos
Cc: [EMAIL PROTECTED]
Subject: Re: Textfile to a 2 column mysql database
Write a quick perl program.
O.S. Bos wrote:
Hi there,
I have a textfile that I want to get inserted into a database. The
textfile consists of Questions
gerald_clark wrote:
Unless, of course, you have quotes in your data.
With perl you can use the quote() function to ensure the whole line
gets in.
Or placeholders.
- Cs.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 4:42 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Textfile to a 2 column mysql database
Unless, of course, you have quotes in your data.
With perl you can use the quote
Hi there,
I have a textfile that I want to get inserted into a database. The
textfile consists of Questions and Answers. 1st line is a question. 2nd
line of the textfile is the answer. And so on...
What is the best way to import these lines into the database with 2
columns. 1 column for the
How do we convert a well-structured XML file to its corresponding tables in
a MySQL Database ?
And
How do we normalize this well-structured XML file prior to conversion ?
This message and any attachments are confidential and intended solely for the
addressee.
Any unauthorized use, alteration
How do we convert a well-structured XML file to its corresponding tables in
a MySQL Database ?
And
How do we normalize this well-structured XML file prior to conversion ?
This message and any attachments are confidential and intended solely for the
addressee.
Any unauthorized use, alteration
www.vbmysql.com
-Original Message-
From: Eldrid Rensburg [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 8:18 AM
To: [EMAIL PROTECTED]
Subject: Is There An Automated Way To Convert A
Well-structured XML File T o Its Corresponding Tables In A
MySQL Database ?
Importance
Eldrid Rensburg wrote:
How do we convert a well-structured XML file to its corresponding tables in
a MySQL Database ?
With your own Perl/Python/C code ...
And how do we normalize this well-structured XML file prior to conversion ?
By basically tracking how deep you are in the nesting
I got these :
| Name | Type | Row_format | Rows| Avg_row_length
| Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_ti
me | Update_time | Check_time | Create_options | Comment
I guess Data_length shows the size in bytes of the table. if
, 2003 16:33
Subject: Re: tables size in mysql database
I got these :
| Name | Type | Row_format | Rows| Avg_row_length
| Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_ti
me | Update_time | Check_time | Create_options | Comment
I guess
Hi there,
How can I see per table size of all tables in a particular database.
Sohail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, Jun 11, 2003 at 10:08:47AM +0500, Sohail Hasan wrote:
Hi there,
How can I see per table size of all tables in a particular database.
SHOW TABLE STATUS
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.13:
Atkinson [mailto:[EMAIL PROTECTED]
Sent: 28 May 2003 13:40
To: [EMAIL PROTECTED]
Subject: [My Solution] Re: Mailing Labels from MySQL database on web
Thanks for all the ideas. Here is a list of the basic paths
suggested along with the comments given for each method. Nobody
claimed any
Le mer 28/05/2003 à 14:34, [EMAIL PROTECTED] a écrit :
From: Landy Atkinson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Mailing Labels from MySQL database on web
Date: 27 May 2003 15:25:20 -0400
What is the best way to approach this? As a temporary measure, I
used an auxiliary
On Tue, May 27, 2003 at 03:43:14PM -0500, mos wrote:
Correct, which is why I have a means of compressing and *encrypting* the
.exe file. I can also lock it to the person's machine (or server) so it
won't fall into the wrong hands.
All such methods have been broken.
If they weren't, the
On Tue, May 27, 2003 at 05:02:47PM -0500, Cal Evans wrote:
2: BETTER
Use PHP to build a PDF on the server in the proper Avery label format and
then serve it up through the web server. If you get this working, make sure
you share how you did it.
Generating postscript from PHP is easy enough;
written up instructions for the end user to follow and
will give it a try as soon as I get MySQL permissions straightened
out. It turns out my ISP sets up only an admin user for the MySQL
database on our site and this user does not have GRANT privileges.
Mailing label printing works fine when MyODBC
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
I could encrypt certain table fields, but this will make
writing the front
end a pain because all SQL statements will now need to be
changed any time
a new column is encrypted.
It also won't help you any, because the
I have a club roster database set up on our web site in which the
underlying data is in a MySQL database. I am using PHP to access the
data and display it on a web page as a phone list, e-mail list,
directory etc. Now what I need it to give the club secretary a way
to print mailing labels
At 02:22 PM 5/27/2003, you wrote:
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Correct, which is why I have a means of compressing and
*encrypting* the .exe file.
I don't understand how this helps... The EXE file has to contain a complete
decryption routine or it can't be
At 11:36 AM 5/27/2003, you wrote:
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
I could encrypt certain table fields, but this will make
writing the front
end a pain because all SQL statements will now need to be
changed any time
a new column is encrypted.
It also won't
-
From: Landy Atkinson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 2:25 PM
Subject: Mailing Labels from MySQL database on web
I have a club roster database set up on our web site in which the
underlying data is in a MySQL database. I am using PHP to access the
data
I have some doubts on how to secure a MySQL database (MyISAM InnoDb)
against people who have physical access to the machine. Here are a few
scenarios.
1) Let's say I want to use MySQL with my vertical market software but I
don't want the customer to have access to my data outside of my
Hi,
Could someone give me some advice on the best way to store sensitive
information like credit card numbers on our mySQL database. Of course we
would be using SSL encryption for all transactions.
Thanks
Neil
_
Stay in touch
On April 1, 2003 07:50, Klepetka, Tom wrote:
Hi -
I would like to access a mysql database server from a NUMA-Q Sequent
platform running Dynix/ptx v4.5.2. Does any of mysql's connectivity
products (Connector/ODBC, Connector/C++) run under this platform/OS?
I am afraid that I don't know
i got this mesage when creating a database for twig, I just followed the instruction
in twig manual on how to create a database but resulted to this
[EMAIL PROTECTED] mysql]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to
: 6345140 Local 1024
Web: http://www.tridel.net
Email: [EMAIL PROTECTED]
- Original Message -
From: Toto Gamez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 2:11 PM
Subject: MYSQL Database
i got this mesage when creating a database for twig, I just followed
Pasig City 1605 Philippines
Phone: 6345140 Local 1024
Web: http://www.tridel.net
Email: [EMAIL PROTECTED]
- Original Message -
From: Toto Gamez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 2:11 PM
Subject: MYSQL Database
i got this mesage when creating
PROTECTED]
Subject: Cannot Update MYSQL Database
I'm running this code with no errors but it's not inserting the string
into the database ?
public void addInfo( String referer )
throws SQLException, Exception {
if (con != null) {
try
I'm running this code with no errors but it's not inserting the string
into the database ?
public void addInfo( String referer )
throws SQLException, Exception {
if (con != null) {
try{
PreparedStatement updateInfo;
updateInfo
I had asked the group previously about limiting the results shown on my
website to a certain number and then navigating to the next group etc...
I found a great article by Joe O'Donnell called Building A Dynamic MySql
Paging Class with PHP ... I created his example and it worked fine.
Then I
]
Sent: Thursday, March 13, 2003 5:20 AM
To: [EMAIL PROTECTED]
Subject: Recordset paging with php on mySql database ... works on first
page but ...
I had asked the group previously about limiting the results shown on my
website to a certain number and then navigating to the next group etc...
I
Is it possible to place MySQL data directories on a Linux ramdisk mount?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Hi,
Is it possible to place MySQL data directories on a Linux ramdisk mount?
Oh yes. No fragmentation aftertaste.
Regards,
Gabriel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I have a column in my mySql database that holds a date that I've added each
record called
designadddate
I'm trying to create a filter to only pull up the records that have been
added over the last two weeks. This is my code ... I added the echo for the
$today and $twoweeksago variables to make
' AND
designs.designadddate = '$twoweeksago')GROUP BY
catcode ORDER BY designfile;
otherwise your getting 2003 minus 3 minus 3 (2003-3-3)
On Monday 03 March 2003 12:01, you wrote:
I have a column in my mySql database that holds a date that I've added each
record called
designadddate
I'm trying
' AND
designs.designadddate = '$twoweeksago')GROUP BY
catcode ORDER BY designfile;
otherwise your getting 2003 minus 3 minus 3 (2003-3-3)
On Monday 03 March 2003 12:01, you wrote:
I have a column in my mySql database that holds a date that I've added
each
record called
-0500 3/3/03, Stitchin' wrote:
I have a column in my mySql database that holds a date that I've added each
record called
designadddate
I'm trying to create a filter to only pull up the records that have been
added over the last two weeks. This is my code ... I added the echo for the
$today
: Monday, March 03, 2003 2:24 PM
To: [EMAIL PROTECTED]
Subject: Re: Selecting from mySql database regarding dates
What happens if you statically set the dates in your query such as this:
SELECT * FROM designs, appliquetable, puffyfoamtable WHERE
designs.designadddate = '2003-03-03
Hello,
I am using mysql 4.0.11 and MyODBC 3.51.05 and
Crystal 9 cannot see the tables of a database.
Any ideas?
thanks, Rafa.
__
The NEW Netscape 7.0 browser is now available. Upgrade now!
Dear sir,
I used mysql-4.0.10-gamma on RedHat-8.0.
I used my.cnf from support-files/my-large.cnf.
When I backup all DataBases I used command below.
mysqldump --all-databases all_databases.sql
I want to know what command to restore Database ?
thank you very much.
Very easy... just copy paste the content of your file
(from mysqldump) into your mysql-client command line.
That's all.
--- Somsak RAKTHAI [EMAIL PROTECTED]
wrote:
Dear sir,
I used mysql-4.0.10-gamma on RedHat-8.0.
I used my.cnf from support-files/my-large.cnf.
When I backup all
At 22:04 +0700 2/27/03, Somsak RAKTHAI wrote:
Dear sir,
I used mysql-4.0.10-gamma on RedHat-8.0.
I used my.cnf from support-files/my-large.cnf.
When I backup all DataBases I used command below.
mysqldump --all-databases all_databases.sql
I want to know what command to restore
On Thursday 27 February 2003 17:04, Somsak RAKTHAI wrote:
I used mysql-4.0.10-gamma on RedHat-8.0.
I used my.cnf from support-files/my-large.cnf.
When I backup all DataBases I used command below.
mysqldump --all-databases all_databases.sql
I want to know what command to
/doc/en/CREATE_DATABASE.html
* http://www.mysql.com/doc/en/DROP_DATABASE.html
This was an automated response to your email 'How to Archive and restore the data in
MySQL database.'.
Final search keyword used to query the manual was 'How to Archive restore the data
database.'.
Feedbacks
In the last episode (Feb 06), Prasad Budim Ram said:
Hi,
Can any of you give me links about Archiving and restoring the data in
MySQL database. Are there any utilities for the same?
http://www.mysql.com/doc/en/Backup.html
--
Dan Nelson
[EMAIL PROTECTED
-file.sql
You can read this back into MySQL with:
mysql database backup-file.sql
[/snip]
here's a recent thread that may help
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msp:129215:aflndljbbfiablpcodgj
olinux
--- Prasad Budim Ram [EMAIL PROTECTED] wrote:
Hi,
Can any of you give me links about
and restore the data in MySQL database.
Hi,
Can any of you give me links about Archiving and restoring the data in
MySQL database. Are there any utilities for the same? Thanks in advance,
Ram
-
Before posting, please check
text, besides its messy etc. does anyone have any suggestions on the best way to
imput text into a mysql database that is simple that will accept what ever text, It
would be great if it could be formated text. But is this possible. Maybe i should be
using a blob field instead of a text field
Prasad,
Can any of you give me links about Archiving and restoring the data in
MySQL database. Are there any utilities for the same?
You can use mysqldump in several ways to backup data, and mysqlimport
or mysql (the command line tool) to import data backuped with
mysqldump. There are many
to imput text and formated text into a mysql
database
Thank you so much everyone for all of your support!
I asked a question re: a mysql post error when the text containd
apostrophe and commas. I got feedback re: delimiting and putting a / before
each comma and appostrophy. The problem
On 8 Feb 2003, at 13:21, ahimsa wrote:
I asked a question re: a mysql post error when the text containd
apostrophe and commas. I got feedback re: delimiting and putting a /
before each comma and appostrophy.
No, it's \ (backslash), not / (slash), and I don't know what your
problem with
on that.
If you want to thank someone, I would just reply to that person, not to the
list.
-Original Message-
From: ahimsa [mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 08, 2003 1:21 PM
To: [EMAIL PROTECTED]
Subject: whats the best way to imput text and formated text into a mysql
database
Thank
if you did. ;)
Regards,
Kevin
- Original Message -
From: ahimsa [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 08, 2003 9:21 PM
Subject: whats the best way to imput text and formated text into a mysql
database
Thank you so much everyone for all of your support!
I asked
each comma and
appostrophy. The problem is that this is not
feasable for me to do this on so much text, besides
its messy etc. does anyone have any suggestions on
the best way to imput text into a mysql database
that is simple that will accept what ever text, It
would be great if it could
301 - 400 of 726 matches
Mail list logo