I have created a back up of our moodle data base from mysql administrator installed in windows version. (dump backup)
I tried to restore it from mysql-administrator latest version for fedora but it gave error message as Ansi-charatcer format or some realated.
then i concentrated on phpmyadmin, I found similar database functionality created for moodle and I have installed that database feature into windows running moodle system and into my fedora local moodle system.
still i can't restore my moodle database.
After doing many tries I think I am near to successfull upgrade. but the latest problem is that when i deleting config.php and restart moodle installation droping previous moodle database and recreating it with new moodle database with moodle database user created accordingly to our windows moodle database username and password, the installation process does create all the tables without any error. But finally it don't allow me to create a admin login and direct me to login to system how could i do so without any login? it ask to create the site. but not give me an option to create a password. Why is that so?
I have phpmyadmin installed in fedora and mysqladministrator installed in Windows.
I read out installing moodle in redhat, Backup faq's for linux, and installation guides also upgrade moodle help file. But those are not resolving or giving clear way of "upgrading a windows moodle system in fedora linux" in a clear step by step way.
can anyone give me exact steps to follow on to come up with this problem. or at least where I can find details and any suggestion
of what can happen in my installation process.
If I understand correctly, you got everything to restore, but you can't login because you don't have an admin username and password?
Your admin username and password should be the same as the previous moodle; however, if you can't get it to work, go into the database after you have it installed on linux and open the mdl_user table. There you should see an admin account. Open that record and you should see an encrypted password. Change it to what you want and select MD5 and save. Then you should be able to login.
Here is the process I generally use to do a migration like this.
In phpMyAdmin. Go into the moodle database. Click on Export. Select all tables. Check complete inserts. Check save to file. (the other defaults should be fine).
Copy the resulting sql file to your new server. From phpmyadmin make the moodle database but leave it empty. Assign appropriate permissions to the moodle database to the username in your config.php file and set it to use the same password as before.
Now from the command line run (note that you can import from the phpMyAdmin screen, but if you have a large database it will likely timeout before finishing).
mysql -u moodle_user -p moodle < moodle-backup.sql
where moodle_user is your moodle database user and the moodle after -p is the database name and moodle-backup.sql is the name of the sql backup file from the original server that you exported via phpMyAdmin.
Copy over your moodle program folder from the old server to the correct folder on the new server. Edit config.php to have the correct new url and root and dataroot. Copy over the moodledata folder and assign permissions so that the apache server can write to it.
Access your new moodle server via its web address to see if everything is working.