Migrating all MySQL from Netware to Suse
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 tables and an ibdata1 file In the old Netware DB there are also ibdata and ib_logfile. I did a mysqldump --single-transaction --quick -uroot -p --all-databases destination_file_name command on the Netware server. Does it include the ibdata* and ib_logfile*? What is the import command for the above mysqldump? TIA Nanu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
MysqlDump destination file
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 destination_file_name, is it possible to add a path before the filename (server\volume\folder) and what is regular\correct file name? TIA Nanu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
mysqldump questions
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
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
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 for Hebrew: Hebrew_bin and hebrew_general ci. What is the difference between them? What shall I choose? phpMyAdmin is 2.64-pl3. System is :Novell 6.5 sp6 - Apache 2, MySQL ver. 4.1.22, 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]
Upgrade from 4.0.26 to 5.0.67
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 List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL select query - newbie
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' v v Table1: access_diff v v Table4: tracks -- v v --- access_diff.DiffLevel tracks.Kvish_Access access_diff.Access_ID v tracks.Track_ID vv vTable2: accesses v v v accesses.Access_IDv accesses.Track_ID v accesses.Site_ID v v Table3: sites v - sites.Site_ID sites.Site_Short_Description RESULTS We want to find all records that: A. 1. 'varKoshi' = access_diff.DiffLevel (Table1) 2. access_diff.Access_ID (Table1) = access_diff.Access_ID (Table2) B. 1. 'varKvish' = tracks.Kvish_Access (Table4) 2. tracks.Track_ID (Table4) = accesses.Track_ID (Table2) C. The common values for accesses.Site_ID (Table2) from A and B are equal to the values in sites.Site_ID (Table3) to retrieve the corresponding records in the sites.Site_Short_Description Table3) as the RESULTS. The query we did is: SELECT sites.Site_Short_Description FROM sites, accesses, access_diff, tracks WHERE access_diff.DiffLevel = 'varKoshi' and accesses.Access_ID = access_diff.Access_ID and tracks.Kvish_Access = 'varKvish' and accesses.Track_ID = tracks.Track_ID and sites.Site_ID = accesses.Site_ID The problem is that not every time all the correct records (possibilities) are found. TIA Nanu
MySQL load and unload immediately
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: sys:/mysql/bin/mysqld.nlm: Character set 'UTF8' is not a compiled character set and is not specified in the 'sys:/mysql/share/charsets/Index' file The log file : MYSQL:/data/WEB.safe contain the following text: MySQL Server 4.0.16a, for pc-netware (i686) address : 0.0.0.0 port : 3306 daemon : sys:/mysql/bin/mysqld base directory : sys:/mysql data directory : MYSQL:/data pid file : MYSQL:/data/WEB.pid error file : MYSQL:/data/WEB.err log file : MYSQL:/data/WEB.safe mysql started: 17 Mar 2006 12:54:49 mysql stopped: 17 Mar 2006 12:54:49 Please help Tia Nanu
בעניין: RE: FOREIGN KEYS
Thanks! Nanu Ing. Edwin Cruz [EMAIL PROTECTED] 10/03/2006 22:06:27 Ive found this on internet: If you re-create a table which was dropped, it has to have a definition which conforms to the foreign key constraints referencing it. It must have the right column names and types, and it must have 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 [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 10 de Marzo de 2006 01:35 p.m. Para: mysql@lists.mysql.com Asunto: FOREIGN KEYS 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 KEYS. The above tool is generating the following query: ALTER TABLE `tiulim`.`pathes` ADD CONSTRAINT `FK_pathes_1` FOREIGN KEY `FK_pathes_1` (`Site_ID`) REFERENCES `sites` (`Site_ID`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `FK_pathes_2` FOREIGN KEY `FK_pathes_2` (`Track_ID`) REFERENCES `tracks` (`Track_ID`) ON DELETE RESTRICT ON UPDATE RESTRICT; After executing the query, it display the error message: MySQL Error Number 1005 Can't create table './tiulim/#sql-84_169.frm' (errno: 150) What is the problem? How to solve it? TIA Nanu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
FOREIGN KEYS
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 KEYS. The above tool is generating the following query: ALTER TABLE `tiulim`.`pathes` ADD CONSTRAINT `FK_pathes_1` FOREIGN KEY `FK_pathes_1` (`Site_ID`) REFERENCES `sites` (`Site_ID`) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `FK_pathes_2` FOREIGN KEY `FK_pathes_2` (`Track_ID`) REFERENCES `tracks` (`Track_ID`) ON DELETE RESTRICT ON UPDATE RESTRICT; After executing the query, it display the error message: MySQL Error Number 1005 Can't create table './tiulim/#sql-84_169.frm' (errno: 150) What is the problem? How to solve it? TIA Nanu