Re: mysql
On Friday 08 February 2002 23:53, Erol wrote: Hi, I have a mysql server on FreeBsd OS and I want to transfer all the database to Debian Linux. Is it possible and How can I do that ? Thanks, erol Hello Erol, for me the best way to do that is: go in the mysql dbase directory (ex. /var/lib/mysq/your_dbase) and brutally copy recursively, your_dbase dir that contains all your .MYD, .MYI and .frm files, in your newdbasesystem. Also there is al lot of ways and utilities in the mysq.com site on how-to replicate and syncronize database. fabrizio -- Fabrizio Tivano WAN System Administrator SAD Trasporto Locale S.p.a. Corso Italia 13/N 39100 BOLZANO e-mail : [EMAIL PROTECTED] Tel: +390471450268 Fax: +390471450253 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: mysql
MYD, .MYI and .frm files, in your newdbasesystem. I doubt this will work, because those binary files are not in a platform independend format and the format even varies between mysql versions. Also there is al lot of ways and utilities in the mysq.com site on how-to replicate and syncronize database. bart, it work... i've been tested importing a dbase from MySQL 3.23.49 to 3.23.39 whitout loss any loss of data and error. same way to use 'standard' mysqldump command fabrizio. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: Securing MySQL
On Tuesday 12 March 2002 09:49, Craigsc wrote: Hi Guys Does anyone know where I can get some good comprehensive documentation on how to secure MySQL running on a Web server. Might be something worthwhile to add to the Securing Debian Howto. Thanks Craig :) Hi Craig, ...there is some ways to make more secure your mysql server, like: host-access lists, user privileges... pls take a look at http://www.mysql.com/doc http://www.linuxsecurity.com/tips/tip-24.html http://www.itc.virginia.edu/desktop/web/mysql/security.html http://www.linux-mag.com/2001-03/mysql_04.html fabrizio -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: help with site+database
Hello, On Tuesday 17 July 2001 10:07, TooManySecrets wrote: Hi. I'm constructing a new site from cero. The actual site is dinamic, with a database server (the DB is over 65 Mb big). The next site also will dinamic, but I would like to change the actual DB (a MS SQL 7) with MySQL or (better for my, I think) a Postgresql DB. The number of visits, actually, is from 9000 to 45000 visits per day. Can anybody tell me what of DB (MySQL or PostgreSQL) are better for me? Can explain me why? Can tell me any site about benchmarks, or any date about that? Any of these databases are too strong to support this number of visitors? The site will run with apache+php4, with database access optimized. Also, we have the Oracle 9i option, but we want to make this project under one of these open source option. Expecially if you have a dinamic PHP site, for me, MySQL and PHP, is the better and faster solution. If you take a look at http://www.mysql.com you can see all about. ... another one, last day i see on a newspaper also NASA migrate to MySQL see ya fabri - --- Fabrizio Tivano technical manager @ karmanet.it tel +39119729007 fax +39119723331 gsm +393385432935 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]