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

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?

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 far

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/ I can send you some simple code to do

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:

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

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 table but not with BACKUP TABLE

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'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:

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. kennM Sale Zenzo wrote: I

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: