ISO: MySQL/phpMyAdmin tutorial for goobs

  • Thread starter Thread starter Porch Dog
  • Start date Start date
P

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?
 
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?
Click to expand...

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 :)
 
burnr said:
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/
Click to expand...

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.
Click to expand...

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.
Click to expand...

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.
Click to expand...

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