SSH into WAMP
Posted by: funkyfrank (---.170.16.17.81.swissinet.com)
Date: August 01, 2015 05:31PM

I would like to learn how to use and run mysqldump with WAMP.

For that I have picked this tutorial post by Chris Coyer:

css-tricks.com/back-wordpress-database/

There it says to SSH into the server.

"To run mysqldump, you'll need to access the command line for your server."

and goes on with

"Some software can help you connect to your server through SSH."

What software do I need for that please? Does WAMP server have a command line tool built into it already? Should I use PuTTY for Windows?

I really like to learn this so that when the sites are on real production/liver servers I know how to make backups and restores of the MySQL databases and what not.

Thank you for any help.

Kind Regards
Frank

Version of Operating system? Windows 7 Ultimate 64bit
Version of Wamp Server installed? 2.5 32bit
Version of Apache you are running? 2.4.9
Version of MySQL you are running? 5.6.17
Version of PHP you are running? 5.5.12
What colour is your WampManager icon? Green
Host file localhost 127.0.0.1

New to WAMP?
Read this please: [forum.wampserver.com]

Options: ReplyQuote
Re: SSH into WAMP
Posted by: RiggsFolly (---.as43234.net)
Date: August 01, 2015 08:50PM

You dont need anything. You or rather your PC is the MYSQL Server.

If you are going to follow a tutorlal, great, but make sure its for the OS you are using, or be prepared to translate the Unix bit to Windows.

to run mysqldump or any of the other mysql tools

run a command window

CD \wamp\bin\msql\mysql{versions}\bin

run the executables from here

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: SSH into WAMP
Posted by: funkyfrank (179.43.144.---)
Date: August 01, 2015 09:31PM

Bang that easy!

They could have mentioned that in the tut though. Makes it hard for beginners like myself.

Thank you Riggs!

Version of Operating system? Windows 7 Ultimate 64bit
Version of Wamp Server installed? 2.5 32bit
Version of Apache you are running? 2.4.9
Version of MySQL you are running? 5.6.17
Version of PHP you are running? 5.5.12
What colour is your WampManager icon? Green
Host file localhost 127.0.0.1

New to WAMP?
Read this please: [forum.wampserver.com]

Options: ReplyQuote


Sorry, only registered users may post in this forum.