Backup your batabases w/o phpmyadmin

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). Where To Buy College Papers 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)… This would be just a reminder 🙂 Use an SSH client, like putty (if your database is on a remote server), to connect to your server and export the databse you want simply with:

http://cheapessaywritings24.com/custom-essays-by-native-english-writers/ Custom Essays By Native English Writers Phd Thesis On Ecocriticism mysqldump –user=username –password=1234 –databases your_database –opt –quote-names –allow-keywords –complete-insert | bzip2 -c > your_database.sql.bz2

Essay On Writer Premchand

download the .bz2 file created, unzip it using 7-zip (if you dont have any other uncompress utility), and backup your database in mysql using:

Essays On Hope mysql –user=username –password your_database < your_database.sql

Essay Writing Service College Admission Download that’s faster than using “import” from phpmyadmin
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Installing PHP5 on Apache server

Today i was trying to install the new PHP5 module on my local apache server.
It’s really simple at least, but when searching for instructions i discovered Research Papers Value Of A College Education WAMP5, which includes in the installation:

  • Apache 1.3.31
  • PHP 5.0.0
  • MySQL 4.0.18
  • PhpMyAdmin 2.5.7
  • sqlitemanager

http://labestetic.pl/best-resume-writing-services-in-new-york-city-zip/ Best Resume Writing Services In New York City Zip I’ve immediately installed it 😉
Once installed you’ll see a new tray icon with some options for your installed services.
I sugges it if you are thinking to install PHP5 on your local machine (i have also a separate apache/php4/mysql3 framework on my machine too, in this way i can always switch trought the two version of PHP/MySQL)

Creative Writing Cardiff