Re: sql2000 to mysql
Victor Pendleton wrote: Are you wanting to move Foreign keys, Triggers, Stored procedures and the like as well or just the data? definitely!! so you make relations in your codes for projects... If not use Triggers, not use Stored procedures then, You move database, table and data with a small script.. -Original Message- From: Tim Winters To: [EMAIL PROTECTED] Sent: 8/24/04 10:36 AM Subject: sql2000 to mysql Hello, Can someone advise me of the best/easiest way to move an entire DB (Tables and data) from sql2000 (my client) to mySQL (my System)? I need to advise someone on how I wish the data sent to me. Any help would be appreciated. Thanks, Tim Best Regards. -- - Davut Topcan -- ~ ~ ~~ ~ -> OTVT Solutions~ ~ -> IT Solutions ~ ~ -> Web Development ~ ~ -> Software Development ~ ~~ ~ -- ~ ~ == JacK == ~ ~ | | ^Daniel^ ~ ~ _ | | ^^~ ~ | |_| | www.NoGate.org~ ~ \___ / www.DTClife.com ~ ~~ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: install problem
Hi, From: "Maria Yndefors" <[EMAIL PROTECTED]> Sent: Tuesday, February 24, 2004 11:54 AM > I have not set the root password and I get the same result hmm.. You should set root password :) Regards, Jack.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: install problem
Hi From: "Maria Yndefors" <[EMAIL PROTECTED]> Sent: Tuesday, February 24, 2004 11:35 AM > mysql -u root mysql > > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: > NO) Try of following; - #mysql -u root -p password - connected in then - mysql> \u mysql; - Regards.. Jack.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: question
Hi, From: "吕世庆" <[EMAIL PROTECTED]> Sent: Saturday, February 21, 2004 10:28 AM > win32: > > Hello! me just download mysql of windows edition,and me have > installed,on the local macheine me have successed.but me have two > question : > one is :if my tool is PowerBuilder ,how to connect to mysql? > the other is :how to connect the network mysql server ? Ansver for one question : I am not know powerbuilder.. Ansver for other question : you write is mysql IP, Port, DataBaseName.. and connect if mysql to mysql then you use mysql client.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: best-practices backups
From: "David Brodbeck" <[EMAIL PROTECTED]> Sent: Wednesday, February 11, 2004 9:27 PM > > > -Original Message- > > > From: Michael Collins [mailto:[EMAIL PROTECTED] > > > > Is there any "best-practices" wisdom on what is the most preferable > > > method of backing up moderately (~10-20,000 record) MySQL 4 > > > databases? A mysql dump to store records as text, the > > format provided > > > by the BACKUP sql command, or some other method? > -- If your operation system is Ms windows then, The Solution is using "batc file" for this problem! -- If your operation system is Linux then, The solution is using "shell script", but attention permissions for Linux.. Ok.. --- Regards.. Jack Daniel from Turkey my web : http://portled.nogate.org --- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database Dump
Hi From: "Swati K" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 15, 2003 1:40 PM > I have just started working on MYSQL. > Can ne one help on How to take a database Backup? Backup; shell # mysqldump table > table.sql for details; http://www.mysql.com/doc/en/Backup.html Best Regards, DT. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]