[OT] phpmyadmin -- trouble importing

[Sadiq Saif]

 I am sorry. I just read the message properly and you seem to be using Windows. Try MySQL Administrator. It's a Windows tool you can use to manage SQL servers, both local and remote. (Look for the restore functionality.)

-- 
Sadiq Saif
Sent with Sparrow

On Monday, December 20, 2010 at 5:02 PM, Sadiq Saif wrote:

>  When you expand the bz2 file, do you get a .sql file? If you do, you can use the terminal to import this onto the MySQL server.
> 
> 
> The command syntax is as follows:
> 
> 
> mysql -uUSERNAME -p NEWDBNAME < /path/to/new/dump.sql
> 
> 
> The new DB name doesn't have to be the same as the old one.
> NOTE - NEWDBNAME must be the name of a database that you have already created using phpmyadmin.
> 
> 
> Good luck!
> 
> 
> -- 
> Sadiq Saif
> Sent with Sparrow
> 
> On Sunday, December 19, 2010 at 8:32 PM, sciguy-Ja3L+HSX0kI at public.gmane.org wrote:
> 
> > Anyone know about or used the phpmyadmin interface for database management?
> > 
> > I am new to phpMyAdmin, and am trying to read a backup of a database from
> > my website on to my localhost machine (a laptop running W7).
> > 
> > My file backup.bz2 is 1.7 megs (expands to about 14 megs), and I have
> > downloaded it locally, and have attempted to read it through a version of
> > phpMyAdmin (3.3.8.1) which comes with EasyPHP.
> > 
> > So, using the "Import" interface, I find my database, then select MySQL323
> > compatability mode (version 3.23 is what my host uses), and I get:
> > 
> > -----8<---------SNIP------------8<--------SNIP------------------
> > Error
> > 
> > SQL query:
> > 
> > --
> > -- Table structure for table `alimentarus_comments`
> > --
> > DROP TABLE IF EXISTS `alimentarus_comments` ;
> > 
> > MySQL said: Documentation
> > #1046 - No database selected
> > -----8<---------SNIP------------8<--------SNIP------------------
> > 
> > Can anyone help me with this error?
> > 
> > Paul King
> > 
> > --
> > The Toronto Linux Users Group. Meetings: http://gtalug.org/
> > TLUG requests: Linux topics, No HTML, wrap text below 80 columns
> > How to UNSUBSCRIBE: http://gtalug.org/wiki/Mailing_lists
> > 
> > 
> > 
> > 
> > 
> 
> 
> 
> 
> 
> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://gtalug.org/pipermail/legacy/attachments/20101220/30603f77/attachment.html>