SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:09 AM
| ||||
| ||||
 Transfering Databases Hi All, I am a Web developer and have been using MySQL for a couple of years. I have just changed to a new development machine away from WinXP to Ubuntu Linux. My Dbase administration in the past has been via MySQL-Admin and SQLYog. I am now trying to bring all my databases into localhost and even under sudo MySQL-admin will not allow a restore! I am not a great command line expert, preferring a GUI. Using phpMyAdmin export/import gives a "#1046 - No database selected " error. I know I am doing something really stupid but I have been setting up this box for 5 days and had minimal sleep. Thanks Rob      |
|
02-28-2008, 05:09 AM
| |||
| |||
| Re: Transfering Databases Rob, are you getting any error messages when trying to restore your MYSQL backups (I assume that you have backed up your databases on the XP system by using the MYSQL Administrator's backup function)? What are these messages? I also suppose that creating blank databases on the Linux system and directly copying the files of each database from the Windows system into their directories on Linux would do the trick (however, I have never tried it between heteregoneous systems - Windows versus Linux). HTH, Panos. On 11/5/06, Rob Cochrane <lists@by-rob.com> wrote: > > Hi All, > > I am a Web developer and have been using MySQL for a couple of years. I > have just changed to a new development machine away from WinXP to Ubuntu > Linux. My Dbase administration in the past has been via MySQL-Admin and > SQLYog. I am now trying to bring all my databases into localhost and > even under sudo MySQL-admin will not allow a restore! > > I am not a great command line expert, preferring a GUI. > Using phpMyAdmin export/import gives a "#1046 - No database selected " > error. > > I know I am doing something really stupid but I have been setting up > this box for 5 days and had minimal sleep. > > Thanks > Rob > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=ptsapralis@gmail.com > > -- Panos Tsapralis, Senior Software / Systems Engineer, +306948076902, Athens, GREECE. |
|
02-28-2008, 05:09 AM
| ||||
| ||||
| Re: Transfering Databases Rob Cochrane wrote: > Hi All, > > I am a Web developer and have been using MySQL for a couple of years. I > have just changed to a new development machine away from WinXP to Ubuntu > Linux. My Dbase administration in the past has been via MySQL-Admin and > SQLYog. I am now trying to bring all my databases into localhost and > even under sudo MySQL-admin will not allow a restore! > > I am not a great command line expert, preferring a GUI. > Using phpMyAdmin export/import gives a "#1046 - No database selected " > error. > > I know I am doing something really stupid but I have been setting up > this box for 5 days and had minimal sleep. Make sure you go into a database before trying to import it. You've done a single database dump which doesn't include a "use database" line at the top - so you need to select the database you want to import to before you start. |
 |
« How many colums should a index contain?
|
when does auto_increment_increment and auto_increment_offset come into being? »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 08:14 AM.
