database backup and restore
Dear all, I have mysql 4.1.11 on my current server, i need my database restore another server.. (another server mysql version is 4.1.11 same.) And now... I just created new my database to new server following command: CREATE DATABASE dbname DEFAULT CHARACTER SET latin5 COLLATE latin5_turkish_ci; because our database and tables uses latin5 and turkish_ci collation. How can i get correct backup and restore for this character sets? example; mysqldump -uUSER -pDBNAME /path/backup.sql and restore; mysql -uUSER -pDBNAME /path/backup.sql is this correct for me? OR mysqldump --default-character-set=latin5 -uUSER -pDBNAME /path/backup.sql and restore; mysql --default-character-set=latin5 -uUSER -pDBNAME /path/backup.sql some peoples suggest me --default-character-set= variable for mysql 4.1.x backups and restore, is this correct? also if we backup database --default-character-set option, restore command is same option will need to use? Which method is good for me? if someone can help me for this, i'm pretty happy. Thanks for all, and sorry for very bad english. _ Yagmura yakalanmamak için sadece semsiyenize degil, MSN hava durumuna güvenin! http://www.msn.com.tr/havadurumu/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
restoring database previous mysql version
Dear Sir, I have 8 mb total SQL database, i'm currently using mysql version: 4.1.11-debian. Our database uses latin5 character set and collate: latin5_turkish_ci And now... how can i restore this database without problem; previous mysql version? previous mysql version is: 4.0.25-standart Note: I have SSH Access. This is very important for me, thank you. _ Hava durumunu bizden ögrenin ve evden öyle çikin! http://www.msn.com.tr/havadurumu/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Remote connection
Hi Gokce, You can check the following (especially the second one); 1. Make sure that you have provided a password to root account on the server box; grant all on * to 'root'@'%' identified by 'your_root_password'; % here means that you can login to your server box as root from any host. However you must provide a difficult to guess password for security reasons because you have added any host with login permission. You may instead only add your client IP replacing with %. 2. Possibly you didn't active the client box's ethernet interface. Make sure pinging from client box is replied from the server box. I wish these above may help you.. If you want to administer you MySQL servers from Windows boxes I may suggest two powerful tools you to search; 1. EMS MySQL Manager 2. M2D - MySQL Database Admin v2.2 Murat. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL ISP
I am searching for an ISP which has MySQL, any suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hi,
Hi, I have a problem i was using mysql and it was very well but yesterday it didn't work then i removed it and reinstalled it , it worked 2 times and then again it doesn't work, when i run mysqld it doesn't run in the background of windows, and in the error file it says 13:05:14 C:\MYSQL\BIN\MYSQLD.EXE: Table 'mysql.host' doesn't exist when i remove it and reinstall it i am able to run it a few times and after a few times, it gives that error, that could be the problem ? thanks, murat, \\\I/// ( o o ) ( n ) ( - ) o0o-o0o | | | Mehmet Murat Yesildal | |BILKENT UNIVERSITY | | Dept : Computer Engineering Information Science | | E-mail : [EMAIL PROTECTED] | | Homepage : http://www.ug.bcc.bilkent.edu.tr/~yesildal | --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re : Hi
Hi Andy, I dont think so to be honest it could be but i removed mysql and reinstalled it several times and each time, it works for a few times and then it collapses... any other idea ??? murat, At 19:13 10.02.2001 +0100, Dingfelder Andy wrote: Hello Murrat, is it possible, that someone deletes your mysql-database or the host table? Maybe yourself? The server needs this table for the "authorization rules", and a deletion should be avoided! Hope that helps. Regards Andy -Ursprngliche Nachricht----- Von: Murat YESILDAL [mailto:[EMAIL PROTECTED]] Gesendet: Samstag, 10. Februar 2001 18:08 An: [EMAIL PROTECTED] Betreff: Hi, Hi, I have a problem i was using mysql and it was very well but yesterday it didn't work then i removed it and reinstalled it , it worked 2 times and then again it doesn't work, when i run mysqld it doesn't run in the background of windows, and in the error file it says 13:05:14 C:\MYSQL\BIN\MYSQLD.EXE: Table 'mysql.host' doesn't exist when i remove it and reinstall it i am able to run it a few times and after a few times, it gives that error, that could be the problem ? thanks, murat, \\\I/// ( o o ) ( n ) ( - ) o0o-o0o | | | Mehmet Murat Yesildal | |BILKENT UNIVERSITY | | Dept : Computer Engineering Information Science | | E-mail : [EMAIL PROTECTED] | | Homepage : http://www.ug.bcc.bilkent.edu.tr/~yesildal | --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php \\\I/// ( o o ) ( n ) ( - ) o0o-o0o | | | Mehmet Murat Yesildal | |BILKENT UNIVERSITY | | Dept : Computer Engineering Information Science | | E-mail : [EMAIL PROTECTED] | | Homepage : http://www.ug.bcc.bilkent.edu.tr/~yesildal | --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php