ISO: MySQL/phpMyAdmin tutorial for goobs

[Porch Dog]

I'm fairly new with MySQL as far as having to access it with the MySQL being
located on a remote server. Is there some tutorials for goobs that explains
how to make productive use of phpMyAdmin for importing/exporting MySQL
files?

 

[burnr]

I'm fairly new with MySQL as far as having to access it with the MySQL
being located on a remote server. Is there some tutorials for goobs
that explains how to make productive use of phpMyAdmin for
importing/exporting MySQL files?

Check this out,
http://www.devshed.com/c/a/PHP/Doing-More-With-phpMyAdmin-Part-1/
http://www.devshed.com/c/a/PHP/Doing-More-with-phpMyAdmin-Part-2/
and
http://www.devshed.com/c/a/MySQL/

I'm still fairly low on the learning curve myself, but if you have the time
to play with it, it's not as complicated as it seems.

What I do is select Export tab, check Structure and data, Select All, check
Save as file, check Zipped, select go. It downloads the zip named with the
database name (thats handy) The compressed file is a .sql file.

Of course you probably know, working with phpmyadmin makes permanent
changes to your database. If you select Drop a table, it is dropped/deleted
and there's no *undo*. Restore a previous backup is the only solution or
re-build the table.

hth

 

[Porch Dog]

Check this out,
http://www.devshed.com/c/a/PHP/Doing-More-With-phpMyAdmin-Part-1/
http://www.devshed.com/c/a/PHP/Doing-More-with-phpMyAdmin-Part-2/
and
http://www.devshed.com/c/a/MySQL/

Thanks...fwd'd this to myself for later perusal.

I'm still fairly low on the learning curve myself, but if you have the time
to play with it, it's not as complicated as it seems.

Yeah...most things I can either figure out or bs into working...but, I've
been working with it locally, here on the servers at my desk, not on a
remote.

What I do is select Export tab, check Structure and data, Select All, check
Save as file, check Zipped, select go. It downloads the zip named with the
database name (thats handy) The compressed file is a .sql file.

Maybe I should try that. I've been dumping to ASCII.

Of course you probably know, working with phpmyadmin makes permanent
changes to your database. If you select Drop a table, it is dropped/deleted
and there's no *undo*. Restore a previous backup is the only solution or
re-build the table.

Yep...knew that it's unforgiving. Thanks for the help.