Re: Converting a postgres database to MySQL

2003-12-08 Thread Zenzo
i think you can because the dump file is a sql file and it is universal for both exception that mysql hasn't subselects. If you havent subselects it should work Matthew Stanfield <[EMAIL PROTECTED]> wrote:Hi, I've been using postgres for a while but have today taken the plunge and installed MyS

Re: How do I convert MDF (MS SQL) to MySQL w/o having MS SQL?

2003-12-05 Thread Zenzo
there is a command but i didnt found it in the documentation. Try dump MS SQL database into a text file and then try mysqlimport. --- Mark Graves <[EMAIL PROTECTED]> wrote: > I run a website using MySQL, PHP, and CFMX. Someone > recently gave a > data file to me that they'd like to access. The >

Re: Record Locking

2003-12-04 Thread Zenzo
I dont know if you can lock entries in a table but a table you can. More info: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Locking_Issues --- Mike Doanh Tran <[EMAIL PROTECTED]> wrote: > hi all, > > Can someone show me how to lock a record in mySQL? > As

Re: Record Locking

2003-12-04 Thread Zenzo
I dont know if you can lock entries in a table but a table you can. More info: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Locking_Issues > --- Mike Doanh Tran <[EMAIL PROTECTED]> > wrote: > > hi all, > > > > Can someone show me how to lock a record in

Re: Images in a table

2003-12-01 Thread Zenzo
I would be pleased. Thanks Glenn Stauffer <[EMAIL PROTECTED]> wrote: Zenzo wrote: >How can I insert images in a table if I can do it with MySQL? > >__ >Do you Yahoo!? >Free Pop-Up Blocker - Get it now >http://companion.yahoo.com/ > >

Images in a table

2003-11-29 Thread Zenzo
How can I insert images in a table if I can do it with MySQL? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

Re: table backup

2003-11-27 Thread Zenzo
The problem is that I wnt to use this remotely on another server. Is there a SQL command for doing this (exporting the table with data into a SQL script)? --- Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > Zenzo <[EMAIL PROTECTED]> wrote: > > how can I backup the tabl

table backup

2003-11-27 Thread Zenzo
how can I backup the table but not with BACKUP TABLE because it Backups the .frm and another files. I want that it backups in SQL with data. How can i do it? Thanks __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Ma

Re: mysqldump

2003-11-26 Thread Zenzo
What mysqldump does? I dont know it because i am new in the world of databases Andre Winarko <[EMAIL PROTECTED]> wrote: I have problem with mysqldump. This query results an error. mysqldump danamon [trx_temp2] > trx_temp2.sql The error message is : mysqldump : Can't get CREATE TABLE for table '

What administrative tasks

2003-11-24 Thread Sale Zenzo
What administrative tasks should I do often on my database? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAI

Re: What's best

2003-11-24 Thread Sale Zenzo
Yes i think it too. I use it but i thought that there are more tolls. --- Kenn Murrah <[EMAIL PROTECTED]> wrote: > IMHO, there's nothing quite as intuitive and easy to > deal with as > phpmyadmin ... i can't begin to tell you how much > time it saves me every > day

What's best

2003-11-24 Thread Sale Zenzo
I would like to know what is the best program for administering MySAQL databases: is it PHPMyAmin or something else? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.