Migrating all MySQL from Netware to Suse

2009-03-16 Thread Nanu Kalmanovitz
Hi! Trying to migrate from Netware to Suse (SLES 10 sp 1 NOWS SBE 2). I already changed the my.cnf file: 1.added a datadir=/MySQL/data line 2.removed the comments from all INNOdb lines The tables on the Netware files are not big On the SLES server I already see a mysql folder containing

MysqlDump destination file

2008-12-18 Thread Nanu Kalmanovitz
Hi! I'm a newbie trying to use the backup\dump command. My questions are: 1. When using the command mysqldump --single-transaction --quick -uroot -p --all-databases, what is the default destination path (server\volume\folder) and the default file name? 2. If using a redirection

mysqldump questions

2008-08-23 Thread Nanu Kalmanovitz
Hi! What is the name dumped file and where it is created? System is :Novell 6.5 sp6 - Apache 2, MySQL ver. 4.0.26, PHP 5.2.3. TIA Nanu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

בעניין: Re: mysqldump questions

2008-08-23 Thread Nanu Kalmanovitz
Thanks! Nanu [EMAIL PROTECTED] 23/08/2008 09:50:13 Whatever you name it Wherever you place it Mysqldump (options) filename -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Language - MySQL connection collation

2008-08-23 Thread Nanu Kalmanovitz
Hi! I just upgraded from 4.0.26 to 4.1.22. On phpMyAdmin with the older (4.0.26) was only one field for Language and it was set to Hebrew (he-iso-8859-i). Now, upgrading (4.1.22) in the Language field appears Hebrew (he-utf-8) and a new field MySQL connection collation: offer 2 possibilities

Upgrade from 4.0.26 to 5.0.67

2008-08-22 Thread Nanu Kalmanovitz
Hi! I wish to upgrade the MySQL on a web server (Novell 6.5 sp6 - Apache 2, MySQL ver. 4.0.26, PHP 5.2.3) to 4.1.2 or 5.0.67. Is there any possibility to upgrade directly from MySQL 4.0.26 to 5.0.67, without upgrading first to the intermediate versions? TIA Nanu -- MySQL General Mailing

MySQL select query - newbie

2006-04-23 Thread Nanu Kalmanovitz
Hi! System is Novell SBS 6.5 sp1 with Apache 2.0.48, MySQL ver. 4.0.15a, PHP 4.2.3. We try to define a select query that takes the values of the variables 'varKoshi' and 'varKvish' based on the following 4 tables: 'varKoshi' vv 'varKvish'

MySQL load and unload immediately

2006-03-17 Thread Nanu Kalmanovitz
Hi! Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL ver. 4.0.15a, PHP 4.2.3, all of them on same machine. After restart server command the MySQL server is loading and unloading immediately. The error file : MYSQL:/data/WEB.err contain the following text:

בעניין: RE: FOREIGN KEYS

2006-03-11 Thread Nanu Kalmanovitz
indexes on the referenced keys, as stated above. If these are not satisfied, MySQL returns error number 1005 and refers to errno 150 in the error message string. Use show create table statement to see table definition (on both)... Regards! -Mensaje original- De: Nanu Kalmanovitz

FOREIGN KEYS

2006-03-10 Thread Nanu Kalmanovitz
Hi! Server system SBS (Novell Small Business suite) 6.5 sp 1 with MySQL ver. 4.0.15a, PHP 4.2.3, all of them on same machine. I just finished create a new DB called TIULIM (InnoDB) with 3 tables (Sites, Tracks Pathes). Now, using MySQL Query Browser ver. 1.1.15, I'm trying to build FOREIGN