First of all i like to say HAI to all members in this FORUM. i know this FORUM is very hot.//////


I am going to reload my server. it is dedicated server for Forum ( vBullein) unfortunately this server is allways slow so i forced to relaod this server, My Question is currently this server has Mysql-4.0 Now after reloding server With Cpanel i will get MYSQL-4.1. but i affraid that is it breake MY VB database. or It will work fine, ?

Thanks in advance
Shadow

You should be able to dump your database and get them converted to MySQL 4.1 format. It isn't really an issue going from mysql 4.0 to 4.1. The problem is if you want to downgrade from 4.1 to 4.0.

How can i dump this. If i backup entire database directory and copy back to new database is it work or not.

Your immediate replay will be highly appreciated.

I'm not completely sure about that, but it should work. Make sure to restart your mysql after you've copied a directory into /var/lib/mysql dir. If it doesn't works, you can just check and repair and optimize all your databases.

mysqlcheck -r -o --all-databases

This is my old server Mysql conf. ( for 4.0)

  Please let me know what changes i should make and also this forum has 40000 users


[mysqld]
safe-show-database
socket = /var/lib/mysql/mysql.sock
skip-innodb
max_connections = 650
key_buffer = 64M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 256M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
thread_concurrency = 4
query_cache_limit = 2M
query_cache_size = 256M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

This post was last modified: 08-16-2006 06:35 AM by alias.