News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Sephiroth.it:
Backup your batabases w/o phpmyadmin
April 07, 2006 @ 07:28:40

As most people, especially those on a shared hosting environment, know, phpMyAdmin can be indespensible for managing your database setup. There are times, however, when you need to work with your databases without it - epecifically in doing a backup. If all you're left with is the command line and you need to make a backup quick, Sephiroth.it has a quick tip to help out.

I often read threads about export/import data from MySQL and it's always mentioned phpmyadmin as the only way to do that (with PHP indeed).

But that's not true, and it's indeed the slower way to do that, expecially when importing large database files (because phpmyadmin has problems with large db)...

He gives an example of the mysqldump functionality, complete with parameters for passing in things like a username and password. The reverse is also shown - reimporting the database data back into the system.

0 comments voice your opinion now!
database backup without phpmyadmin mysqldump export import database backup without phpmyadmin mysqldump export import


blog comments powered by Disqus

Similar Posts

Zumba Engineering Blog: Incorporating Mongounit into Multi-datasource Models with Traits

Jeremy Cook's Blog: Handling Binary Data with PDO

Jani Hartikainen's Blog: Unit testing 4: Mock objects and testing code which uses the database

Rob Morgan: Getting Started With Phinx

Lorna Mitchell's Blog: Script for Database Patching at Deploy Time


Community Events

Don't see your event here?
Let us know!


series laravel configure voicesoftheelephpant language release example part2 conference opinion podcast interview symfony2 framework php7 introduction performance api application community

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework