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 …

More

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 databasename …

More

Mysql 4.0 and Mysql 4.1 Compability

My friend install serendipity (blog engine) in his laptop with mysql version 4.1.21 and dumping sql of his blog. When I try to restore sql file in his PC I got error message : Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Administrator>cd c:\appserv\mysql\bin C:\AppServ\mysql\bin>mysql -uroot -p alam < blog.sql Enter ...

More