Loldb migration problems

Loldb migration problems 1: loldb. *. when a problem occurs when the com website is migrated from one machine to another, the session is lost. When switching between English, German, and Russian, the session is lost, prompting you to enter the user name and password, at first, I thought it was a time zone issue. Later I decided it was not the cause that was finally found: the session name and php specified in the php program. different in ini; session. name = ECSESSID # default session configuration. name = PHPSESSID heh php. ini configuration problems! 2: loldb is migrated from the original machine to the new machine. There are a lot of pictures. # loldb migration takes two days. After the web data is not imported, the resolution is directly modified! Cause: the image file is not stored in svn server. Images are uploaded through the loldb background. Because of the two-day interval, I lost a lot of image files. At first, I wondered how I could lose my images! 3: For database migration on the loldb website, I checked the loldb file and found that the file format of the MyISAM storage engine was actually the file format of MyISAM. After compressing the database, I modified the configuration file, removed the original ib_data and several log files, and restarted mysql. After mysql was started, I found that the website could not be properly displayed, it turns out that one of the tables in the loldb database is in innodb format. I directly removed the ib_data file, causing data loss! Solution: Modify the storage engine of the table, change it from innodb to MYiSAM, or export the loldb database to SQL, and then import it directly on the new machine! 4: You can use the mail function after installing postfix and sendmail (no additional configuration is required !): Test method: mail-s "Hello Xiaojie" 76445449@qq.com <mail.txt 5: colleagues use windows 2008 virtual Several linux virtual machines, but on the linux virtual machine can not find the network card! Solution: in hyper-v, the linux virtual machine cannot find the NIC. The problem is that the linux virtual machine does not have the NIC Driver in hyper-v, the solution is to delete the network adapter in the virtual machine settings of hyper-v, then add hardware-add an old network adapter-select the external network, and then linux recognizes the network adapter after the boot, that's simple. 6. Problems Encountered during mysql database migration: 130506 1:52:51 [ERROR] Missing system table mysql. proxies_priv; please run mysql_upgrade to create it130506 1:52:51 [ERROR] Native table 'performance _ schema '. 'events _ waits_current 'has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'events _ waits_history 'has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'events _ waits_his Tory_long 'Has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'setup _ consumers' has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'setup _ instruments' has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'setup _ timers 'Has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'Performance _ tim Ers' has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'threads' has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'events _ waits_summary_by_thread_by_event_name 'Has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'events _ waits_summary_by_instance 'has the wrong structure130506 1:52:51 [ERROR] Native table' per Formance_schema '. 'events _ waits_summary_global_by_event_name 'has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'file _ summary_by_event_name 'has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ schema '. 'file _ summary_by_instance 'has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ schema '. 'mutex _ instances' has the wrong structure13 0506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'rwlock _ instances' has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'cond _ instances' has the wrong structure130506 1:52:51 [ERROR] Native table 'performance _ scheme '. 'file _ instances 'has the wrong structure130506 1:52:51 [Note] Event Scheduler: Loaded 0 events130506 1:52:51 [Note]/data/mysql/bin/mysqld: ready Connections. # the above is the mysql background log error! Solution: Version: '5. 5.30-log 'socket: '/data/mysql. sock 'port: 3306 Source distribution [root @ loldb var] #/data/mysql/bin/mysql_upgrade # Start the Looking for 'mysql': /data/mysql/bin/mysqlLooking for 'mysqlcheck' as:/data/mysql/bin/mysqlcheckRunning 'mysqlcheck' with connection arguments: '-- port = 3306 ''-- socket =/data/mysql. sock '/data/mysql/bin/mysqlcheck: Got error: 1045: Access den Ied for user 'root' @ 'localhost' (using password: NO) when trying to connectFATAL ERROR: upgrade failed [root @ loldb var] #/data/mysql/bin/mysql_upgrade-uroot-pku ***** 1601 # Add the user name and password to the Looking for 'mysql as: /data/mysql/bin/mysqlLooking for 'mysqlcheck' as:/data/mysql/bin/mysqlcheckRunning 'mysqlcheck' with connection arguments: '-- port = 3306 ''-- socket =/data/mysql. sock 'running' mysqlcheck 'With connection arguments:' -- port = 3306 ''-- socket =/data/mysql. sock 'mysql. columns_priv OKmysql. db OKmysql. event OK 7: The backup script is written and uploaded over ftp, but no ftp command is found. solution: the ftp command cannot be found in linux. At first, I tried to install vsftp, after the installation is successful, the ftp command still cannot be found! Solution: yum-y install ftp 8: loldb after entering the user name and password, the login fails. you can log on only once after Refresh: At first I think it is a database problem, because the default configuration file used by mysql is used, the load is too large, so there must be a problem! Therefore, the configuration file is adjusted, and there is still a problem after the adjustment: Fault error, [root @ ****** logs] # cat error_log | grep http: // l ** db. ***. com/user/login [Mon Apr 22 05:17:52 2013] [error] [client 122. **. **. 98] PHP Fatal error: Call to undefined function mcrypt_encrypt () in/var/www/html/data/app/***/pro *** ted/com *** nT/m. php on line 732, referer: http: // l *** B. ***. com/user/login [Mon Apr 22 09:09:57 2013] [error] [client 122. ***. ***. 98] PHP Notice: Trying to get property of non-object in fault cause: the mcrypt_encrypt () function is required in the php program, and the corresponding php extension is not installed on the machine! Install the mcrypt extension.