Final decision has been made, upgrade to mysql 5.0 is a must. But how to do that? How about user data? After doing it by myself I found it’s easy. I try to share my experience in sbs (step by step) form 🙂 Situation : I have two server kongja and proxy : Server kongja […]
Category: Database
Backup and Restore many mysql database in one shot
Its my bad for not reading database manual that lead me for doing boring task . Dump a few database from server and dumping it in my windows xp. one by one. Perhaps someone who see this post can learn and not doing same mistake as me. Command to backup one database : backup database […]
Diff database structure with sqlyog
When requirement for information stored in database grow, old table structure need to adjust for flexibility. Common task to do in normal cycle : 1. Build new application in other place 2. Synchronize database ( tables) 3. Upload application. Second step ( synchronize tables) often painful when a lot of changes made at home and […]
Installing your favorite mysql version in FreeBSD
which server mysql version you want? is it 4.0, 4.1, 5.0 or 5.1 you control your rules
Some mysql sql basic command I must remember
I use phpmyadmin in daily environment, do I still know sql command? My sql file too large, it’s hard to import using phpmyadmin, please help me Some question around mysql from my student, my false make them spoil using phpmyadmin all day long 🙂 Here’s my answers : 1. Command to create database create database […]