Ssh
This is a discussion on Ssh within the Server / Technical Administration Tips and Queries forums, part of the Webmaster Help category; Thanks guys although i'm really lost now. I'm new to Cron jobs and MysqlBackups etc. I've attached the Cron window ...
| |||||||
| Register | Forum Rules | FAQ | Donate | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
06-01-2008, 02:12 PM
| ||||
| ||||
 Thanks guys although i'm really lost now. I'm new to Cron jobs and MysqlBackups etc. I've attached the Cron window option that i can see through my hosting365 CPanel. How would i input the code above in here? I know how to put together batch files etc. on windows but this has me lost  How do i input the -h switch?         |
|
06-01-2008, 02:16 PM
| |||||
| |||||
| Code: mysql -u your_dblogin -pyour_password -h your_mysqlsubdomain.yourdomain.com your_db |
TOTW/F/M Award(s): 1
|
06-01-2008, 02:19 PM
| |||||
| |||||
| Quote:
you'd then point to this file /home/path/to/file.sh in your cron window you'd put in maybe 30 0 * * * /home/path/to/file.sh into the image you showed us this will run your script at midnight .. 30 minutes in ... every day .. every month .. every day of the week I'd say to do it at half past ... as depending on the server load and what others are doing it could be quite high so I like to use non critical times to do backupts
__________________ Forbairt Media | Web Design & Development Galway / Dublin, Ireland - coming soon ... ( vague but descriptive isn't it ) Recent Work: Safari Club African Safari Holidays - Malawi Safaris Other Stuff: FluffyLinkulator Rapid Inclusion Service Tools Jumper Stuff: Task Drop's Official Geansai Gorm Website Last edited by Forbairt; 06-01-2008 at 02:22 PM. Reason: added some more info on the time |
|
06-01-2008, 02:24 PM
| ||||
| ||||
| Thanks Forbairt. Will give the sh file a try soon today. I've tried the -h option and i'm getting closer i think. It is now giving me the error that it cannot find table "MyDBName" with the following command mysqldump -u MyUsername -pMyPassoword -h sql5.hosting365.ie MyDBName > testDB.sql Any idea? |
|
06-01-2008, 02:37 PM
| |||||
| |||||
| can you print out the exact error ? it wasn't to do with lock tables was it ? |
|
06-01-2008, 02:51 PM
| |||||
| |||||
| I'm sorry to ask this ... but ... you have changed "MyDBName" to the actual database name you are using ? (it pained me to ask it sorry ... I'm just stumped otherwise) |
|
06-01-2008, 02:54 PM
| ||||
| ||||
 yes i have changed the name to the actual DBName.I'm looking at this script at moment to see will it work too MySqlDump database backup |
|
06-01-2008, 02:55 PM
| |||||
| |||||
| BTW ... I've also got to ask and it doesn't solve your problem via ssh .. but why not just use hosting 365's install of phpmyadmin to export your database ? (but if you are requiring a regular cron job then that isn't the way to go) |
|
06-01-2008, 03:10 PM
| ||||
| ||||
| I've tried using PHPMYAdmin already and have got it to export but when i try to import it into a new database, i receive errors so i thought i'd look into SSH etc. The more i read, the more now i think that i have to setup daily cron jobs. I'll email support @ Hosting to see have they any idea why the mysqldump command isn't working through putty |
 |
| Tags |
| ssh |
« How long does it take for dns changes to propagate?
|
How to get Apache 2 Test Page back - CentOS 5 »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| changing permissons via ssh | Cormac | Server / Technical Administration Tips and Queries | 5 | 15-08-2006 11:29 PM |
| ||||||||
| |  |  | ||||||
All times are GMT +1. The time now is 11:25 AM.
