WampServer

I have set up Joomla 1.5.6 on a wamp server with MySQL version 5.0.51a. My live server is using MySQL 4.1.20 and when I export the database from the wamp installateion an import it to the live server I get the message:

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.11.5
-- [www.phpmyadmin.net]
--
-- Host: localhost
-- Generation Time: Aug 17, 2008 at 06:56 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.5
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

MySQL said: Documentation
#1193 - Unknown system variable 'SQL_MODE'


I tried to export Categories, Sections, Menus and Articles only, because that is the information I need to transfer, so I exported jos_categories, jos_sections, jos_menus and jos_content in different formats (sql, csv..) and tried to import them on my live server. When I use csv amd choose Replace table data with file I get the message:


Error
Invalid field count in CSV input on line 1.


When I export and import data on the same MySQL version, it works fine. I also did a reinstallation of wamp with the newest MySQL 5.0.51b but that version could also not import the database from MySQL 5.0.51a.

How (on heavens earth) do I transfer data from one MySQL version to another???

Grateful for answer
Rajan

are they the same storage type?

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Mmm. What do you mean by same storage type..?

[dev.mysql.com]

the 2 most popular are myisam and innodb ;-)

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

No, it doesn't look like it. On the live server MyISAM is the default storage engine. On wamp InnoDB is the default storage engine, although I see MyISAM is available as a storage engine on wamp also.

What can I do?

Try this

Left click on wamp tray icon, then MySQL, then my.ini

Find:
default-storage-engine=InnoDB

Change to:
default-storage-engine=MyISAM

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

I changed it from InnoDB to MyISAM, but I still get the same errors when importing the whole database or just jos_content.

I see that in phpMyAdmin on the wamp server there is a column saying Collation - latin1_swedish_ci
This column is not on the live server. Does this has anything to say?

instead joomla, try to create a very simple db on host then export and import it to local to see if you still have same problem

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Aaaaaaaa, there goes my knowledge limit... I'm more of an out-of-the-box user with the ability to do some changes and adjustementes, but when it comes to creating a db outside of Joomla, I'm afraid I meet my limit.

But I cannot possibly be the only one with the need of migrating some data from one Joomla installation to another, without also having to drag all extensions and components with it... It's more like creating a migrating script like the sample data that comes with the Joomla installation. No?

I don't have any problem to migrate Joomla, so I'm not sure if it's the conflict b/w your host and local or your way, so use this to make a simple db

[guides.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Yihaa, nice guide. I created a db and the Migration in Joomla went successfully (partially) - it could connect to the new database.

BUT - in PHPAdmin, the new datebase is still empty - no tables - after the migration. That is a bit odd, isn't it?

I bet you are using two different versions of MySQL.

comment or delete the line from your sql: SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";


When you export from phpmyadmin, select the compatibility option for MySQL 4.0

I am using the same MySQL version - 5.0.51a - and they are both on the wamp server.

How do I comment or delete the line from my sql?

I am not exporting from phpmyadmin - but using the mtwMigrator, and there is not the option for setting compability for MySQL 4.0

(Why is this so difficult..?)

Quote

they are both on the wamp server.

That's why you get this error

Quote

BUT - in PHPAdmin, the new datebase is still empty - no tables - after the migration. That is a bit odd, isn't it?

Since your script import db in 1 while phpmyadmin display another :-(

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

OK, at least the mtwMigrator worked, so it looks like it is the connection with my web host mysql that didn't work so well. I have changed my webhost, because I wasn't so happy with them, so tomorrow I should be able to access a mysql db on a new host. Then I will try again.

Thanks for your huge effort in trying to make this #%&¤!! work. I will succeed!! :-)

GOD, how I hate wasting time. I have spend 10 hours with my new host, one.com, which I at this point dearly regret transfering to, only to experience that nothing I tried today worked. They do also not provide an url for mysql, so I cannot use mtoMigrator.

So is there a way to make a migration to a different db locally on my computer? I give up trying to connect with mysql on my hots's server.