Re: Database migration from Access to MySQL

2009-11-25 Thread Sridhar Dhanapalan
2009/11/24 David Bowskill : > Hello All > > The way I understand it, the first task is to dump the Access file as a > CSV file and feed this into a ODBC /MySQL driver to create MySQL tables > - is this correct? There are two ways I've used: * MDB Tools * Pentaho Data Integration The former can

Backup and restore onto different hard drive

2009-11-25 Thread Ryan Ralph
Hi everyone, Was just wondering if someone could explain to me how the best way to go about backing up my setup at the moment. What I need to do is do is take a "ghost image" (windows term) of my 120gb hard drive that ubuntu is currently installed on and then restore it onto one of my newer 500gb

Re: Backup and restore onto different hard drive

2009-11-25 Thread Matthew Hannigan
I'd use the -a option to cp rather than dd. dd preservies/copies far more than you want or need, and requires you to resize afterwards. So.. cd source && cp -a . destination Are you ok with the grub stuff? On Thu, Nov 26, 2009 at 12:06:44AM +1100, Ryan Ralph wrote: > Hi everyone, > > Wa

Re: Backup and restore onto different hard drive

2009-11-25 Thread Ryan Ralph
I think I can manage to work out the grub stuff. Is it possible to guarantee all data will be copied exactly or is that what the -a option does? -- Ryan Ralph ryanralph1...@gmail.com On Thu, Nov 26, 2009 at 2:11 PM, Matthew Hannigan wrote: > I'd use the -a option to cp rather than dd. > dd pre

Re: Backup and restore onto different hard drive

2009-11-25 Thread Sridhar Dhanapalan
2009/11/26 Ryan Ralph : > Hi everyone, > > Was just wondering if someone could explain to me how the best way to go > about backing up my setup at the moment. > > What I need to do is do is take a "ghost image" (windows term) of my 120gb > hard drive that ubuntu is currently installed on and then r

Re: Backup and restore onto different hard drive

2009-11-25 Thread Sridhar Dhanapalan
-a does an 'archive' copy, meaning that it tries to preserve as much as it can (permissions, etc.). If you choose this option, don't use it to copy a live system. I still think that something like clonezilla is a better alternative. You preserve the entire filesystem and all its metadata, and you