[OT] phpmyadmin -- trouble importing

[Sadiq Saif]

 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/feab997c/attachment.html>