Re: How to summarize weekly totals?

2006-10-28 Thread Peter Brawley
>Some days may be missing if it is a holiday, which means I can't >guarantee each week will have a sales row for Monday or Saturday. >Do I need to write a program to do this? Or can it be done with SQL? TIA Group by WEEK(sale_date), or build a calendar table and join from it. PB mos wrot

migrate

2006-10-28 Thread Mohsen Pahlevanzadeh
dear all, I wanna dump my wiki bank to a RHEL linux,My source bank is in the ubuntu Linux. My target distro has mysql 4.1.20 When i dump from source,It creates a dump 25MG,But when i export it,it dump 4k only,I have tested it via phpMyAdmin,Mysql_dump & webmin. Please help me.. --Mohs

Migrate

2006-10-28 Thread Mohsen Pahlevanzadeh
Dear all, I have an ubuntu & wiki in that. Now i export my wiki bank,So i dump a 25MG. When i import to my target,it dumps just 4K. My target is RHEL & mysql 4.1.20 Please help me... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://list