Hi all,
I'm following the instructions [1] to convert character set. Unfortunately I get
warnings about truncated data for some rows in several columns. All the
truncated columns are text type.
Assuming the `col' column is text type and actually contains correct utf8 data
but has wrong character
Can someone either answer or point me somewhere for the answer?
I am attempting to store text lines from an e-mail message into a MySQL
table through the use of Perl and DBI. Periodically I get the error that
states there was an error in the statement and to check the syntax. I know
it has
Duane Hill wrote:
Can someone either answer or point me somewhere for the answer?
I am attempting to store text lines from an e-mail message into a MySQL
table through the use of Perl and DBI. Periodically I get the error that
states there was an error in the statement and to check the
Hi All,
Thank you for u r valuable suggestions. I am trying to implement Sequence.
As i should not use AUTOINCREMENT, and Locking a table will slower my
application.
Thank you once again.
I'm trying to determine the best way to back up my MySQL databases in such a
way that they can be easily restored, flexible, and complete. I've
experimented with physically copying the files (with disastrous results).
MySQLDump seems to be the way to go, but I've got two problems with that
On Mon, 3 Jul 2006, Stefan Hornburg wrote:
Duane Hill wrote:
Can someone either answer or point me somewhere for the answer?
I am attempting to store text lines from an e-mail message into a MySQL
table through the use of Perl and DBI. Periodically I get the error that
states there was an
Jesse wrote:
my editor forces a hard line break at column position 16384, which, of course, corrupts
the restore. I don't know if there are other text editors that will not do this,
Funny, i've never seen one that does? What system/editor are you using?
or even better, if there is a way
On 7/3/06, Jesse [EMAIL PROTECTED] wrote:
I'm trying to determine the best way to back up my MySQL databases in such a
way that they can be easily restored, flexible, and complete. I've
experimented with physically copying the files (with disastrous results).
MySQLDump seems to be the way to
Funny, i've never seen one that does? What system/editor are you using?
Multi-Edit version 8.0i. This is an older version of the editor. Maybe a
newer one wouldn't, but for the most part, it does a very good job for me.
try to use the --max_allowed_packet= option - afaik mysqldump will
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer using
the package which
Jesse wrote:
Funny, i've never seen one that does? What system/editor are you using?
Multi-Edit version 8.0i. This is an older version of the editor. Maybe
a newer one wouldn't, but for the most part, it does a very good job for
me.
Ok never heard of multiedit... if your system is
--routines, -R
and
--triggers
Thanks, these did the trick, and it's put my procedures and triggers into
the back up file. However, it has commented them out so that they will not
be created if I do a restore to a new database. Not sure why...
Change Editor ;-)
I personally use VIM and
2) sometimes, I like to copy just a single table or so out of the backup
file, and restore just that.
You might want to try out MySQL Administrator which can often be used to
restore backups from mysqldump. It can _selectively_ restore tables from a
backup file.
Chris White wrote:
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer using
On 7/3/06, Jesse [EMAIL PROTECTED] wrote:
--routines, -R
and
--triggers
Thanks, these did the trick, and it's put my procedures and triggers into
the back up file. However, it has commented them out so that they will not
be created if I do a restore to a new database. Not sure why...
also, i would check that the user you are using for your mysql_connect in
php has the permissions to do the create table, etc.
On 7/2/06, Daniel Kasak [EMAIL PROTECTED] wrote:
Brian Menke wrote:
MySQL version 5.0.16
Windows XP
PHP 5.
I have this query that when I run it in SQL
Jan Gomes wrote:
Pardon me, i think I din't express myself properly.
I did not only combining data elements.
My structure was:
Table_1{
id_table1 (int)
COLLUM 1 (int)
COLLUM 2 (int)
}
Table_2{
id_table1 (int)
COLLUM 1 (int)
COLLUM 2 (int)
}
Being a relationship between
There's GVIM for Windows, its the same program of Linux, I use it when
there's no way but using Windows. Get it at www.vim.org ! Its a blast
having the same (powerful, easy, fast and reliable) tool in windows
and linux. But you'll find it kinda hard to learn at first, because of
the command mode.
Oh, OK. I use MySQL Administrator frequently, but didn't realize that it
could selectively restore. I don't like to use it for backups, because it
doesn't get --routines and --triggers, and also doesn't backup in the format
that I use. But I'll consider that.
Thanks,
Jesse
- Original
Chris White wrote:
On Sunday 02 July 2006 12:22 pm, Kirti S. Bajwa wrote:
I have very little knowledge of either PostgreeSQL or mySQL. Please advise
me as to which of these two software package to use? I need some specific
examples as to superiority of one package over the other. I prefer
On 7/3/06, Jesse [EMAIL PROTECTED] wrote:
There's GVIM for Windows, its the same program of Linux, I use it when
there's no way but using Windows. Get it at www.vim.org ! Its a blast
having the same (powerful, easy, fast and reliable) tool in windows
and linux. But you'll find it kinda hard
GVIM is a great transition from vi to more 'modern' (read slower and
cumbersome!) editors.
It allows all the normal vi commands, but also 'standard' Windoze features like
Ctrl-C Ctrl-V for copy and paste, drag and drop selection etc.
Like all good editors, it takes time to get the most out of
so i am doing a query on an enum field:
when i do this query:
select *, id as vid, user_id as uid from video where (file_complete =
'true') order by undt desc limit 0,10;
the results are 0.16 or 0.17 seconds.
instead of saying file_complete = 'true. if i say file_complete != to the
other 5
Dear Sir/Madam
I am working on a project where I am
to use PHP as front end and MYSQL as backend.MySQL
stand alone is working properly,but it is not
connecting with PHP.Please tell me solution.
__
Do You Yahoo!?
Tired of spam?
sharvan kumar wrote:
Dear Sir/Madam
I am working on a project where I am
to use PHP as front end and MYSQL as backend.MySQL
stand alone is working properly,but it is not
connecting with PHP.Please tell me solution.
Connect it.
--
Daniel Kasak
IT Developer
NUS Consulting
25 matches
Mail list logo
