databases from winxp to linux

[spiderx]

Can anyone tell me the best way to get my databases from winxp to work on linux?

[sfboarders]

Use PHPMyAdmin

[spiderx]

lol I am totaly new to linux

I followed directions on how to install phpmyadmin and it was successful except for the fact that when I click on any link within phpmyadmin it goes to microsoft home page lol


can anyone please help

[Jman]

What database? Probably Access. You'll probably want to save it into a SQL database such as MySQL or PostgreSQL. Here's an article about Access to MySQL

[sfboarders]

As Jman asked what type of db are you transferring? I use PHPMyAdmin to backup MySQL data from my websites. Is this the kind of data you are transferring?

[sanchay]

Hey spiderx.
What exactly do you need to do? Is it that you were running ms access and now you want that to run on linux. Which database anyway are you using in your winxp machine? Or is it that you want all the data on your winxp database to be transferred to your linux machine? Clarify as below:
1. your objective (like what do you want to do. transfer db schema, transfer db schema + data etc)
2. the database engine on your winxp machine
3. the database engine on your linux machine (msql, mysql etc)
Sanchay

[spiderx]

transfer db schema + data from my websites. mysql in winxp to new mysql server on linux.

I tried export and import with phpmyadmin but I get errors.

[Jman]

What errors? The MySQL manual may help.

[latcarf]

I need to resurrect this thread if i can. I just installed FC4 and am using the stanton-finley.net install guide. I did everything (twice to make sure!) and when I get to the login page for phpmyadmin and log in I also get the Microsoft home page!? As I said I went through the set up again using copy/paste and everything "seems" to be fine until I log in.

Any ideas? I am not sure about the "My SQL super user password". Is that my root password? I enterd a passphrase in the config.inc.php but it is my understanding that is not the password because it did not work either.

Edited to add: I went back and redid the config file and set auth_type back to "config" and set a password in the next line and it worked perfect. This means something is missing/wrong in the auth_type "cookie". Cookies are enabled...

[sanchay]

Did you set the
$cfg['PmaAbsoluteUri'] = 'http://www.your_web.net/path_to_your_phpMyAdmin_directory/'; in the config.inc.php file in your phpmyadmin folder?

[latcarf]

not exactly...

the install guide says "Hit enter and gedit will open. In /var/www/html/phpmyadmin/config.inc.php change "$cfg['PmaAbsoluteUri'] = '';" to "$cfg['PmaAbsoluteUri'] = ' http://whatever.com/phpmyadmin/';" so I changed the latter to ' http://mysite.net/phpmyadmin/';.

Are you saying it should look like this: ' http://www.mysite.net/var/www/html/phpmyadmin/'; ?

This problem may trace back to the MySQL section of the guide. when I edit "skip-innodb" into the my.cnf file the $ mysql -u root" command fails. Returns #ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Now this worked last night until I made this change ""$cfg['Servers'][$i]['auth_type'] = 'config';" to "$cfg['Servers'][$i]['auth_type'] = 'cookie';" in the config.inc.php file. That is when it took me to the M$ home page. When I did restart on mySQL it failed, time out once said something about it being dead another. I did some monkeying around still got M$ then undid the changes and it worked.

If I leave out the "skip-innodb" and leave [auth_type]= "config" plus I had to add a password to the next line it all seems to work. I guess I need to know what the purpose of those two changes in the install guide are for? This is all new to me I am kind of nervous about having a file with a open password in it on my system.

Would it be easy to uninstall mySQL and php and start over? or reset them back to original config? I have no clue yet how to do either.

[kosmosik]

export them to SQL on Windoze and import on Linux.

[latcarf]

what am I exporting? I have Windoze on my other machine but it is XP Home so it really does not have any NT capabilities. I seem to be having enough fun learning Linux and BIND and such so I don't want to tackle trying to learn M$ applications at the same time!

As of last night I couldn't even open the BIND configuration window because of zone file errors. I came by the forum this morning to search on how to uninstall and reinstall BIND so I can start over.

I do not even know why I need mySQL, php, and myphpAdmin at this point. I was only following the install guide for FC4 I was linked to earlier in this forum. This is all new to me and I jumped in with both feet but I think I wil eventually need these programs to develop and implement interactive web pages from my server.

For now I would just be happy (real ) to get BIND and a nameserver running for my domain.