[CLUE-Tech] Creating a database with phpmyadmin?

[Young, Ed]

Thanx for all the replies. 

I used mysqldump and it went something like this: 
Mysqldump dbname > dbname.sql

I'm away from the machine so I'm trying to do this remotely using
phpmyadmin. (version 2.5.3)...

I'm able to create the db easy enough but it doesn't look like I'll be able
to read in the file since when I choose "browse" from within the SQL
function (link) it of course opens up a browse view of the local machine I'm
running, not a browse view of the server where the machine is and where the
dump file is.  

So this will have to wait until I can get in front of the machine I'm
administering or if I can get the mysqldump text file local and try it
again. 

Thanx again for the replies and I'll report back how this works out. 

Anyone else feel free to make further suggestions, since this is spurring me
on to get familiar with MySQL, phpmyadmin, etc and to (finally) get things
migrated to a different machine. 


> -----Original Message-----
> From: Steve Fry [mailto:cluelist at ir3w.com] 
> Sent: Monday, November 24, 2003 10:09 AM
> To: clue-tech at clue.denver.co.us
> Subject: Re: [CLUE-Tech] Creating a database with phpmyadmin?
> 
> 
> Ed:
> 
> > I want to move a mysql database from one machine to 
> another. I managed 
> > to dump the database to a file using mysqldump and now want to 
> > recreate the database on another machine.
> 
> > Can I use phpmyadmin to create/populate it?
> 
> Yes.  
> 
> While I (obviously) don't know which version of phpMyAdmin 
> you're using, on mine, I copy/create databases as follows:
> 
> Use the "Export" function (link), "Structure and Data", "save 
> as gzipped" to grab your existing DB.
> 
> Use the "SQL" function (link), "Or Location of the textfile", 
> "gzipped" to upload your new DB.
> 
> Steve
> 
> 
> 
> 
> -----------------------------------------------
>               IR3W Web Services
>    Steve Fry - steve at ir3w.com - 720-233-3WWW
>     Web Site Design, Development, and More!
>              http://www.ir3w.com
> -----------------------------------------------
> _______________________________________________
> CLUE-Tech mailing list
> Post messages to: CLUE-Tech at clue.denver.co.us
> Unsubscribe or manage your options: 
> http://clue.denver.co.us/mailman/listinfo/clue> -tech
>