Toll Free: 1-877-695-7388

GTA: (647) 699-2838

Search Engine People
  • SEO
  • SEM
  • CRO
  • Display
  • Blog
  • Why Us
  • Contact
  • Join Our Team
  • Get A Quote

Toll Free: 1-877-695-7388

GTA: (647) 699-2838

Backing up dynamic content remotely

Donna Fontenot | August 8th, 2004
Tweet
Share
Share
Pin
0 Shares

If you serve dynamic content using a MySQL database, you probably have a way to backup the table structure and data using your server control panel. Most likely, you have access to phpMyAdmin or shell access to create a mysqldump.

I encountered a problem recently that forced me to look for a way to backup a remote MySQL database without using my hosting companys phpMyAdmin nor mysqldump. My hosting company is in the process of changing servers, so for some reason I am unable to login to the phpMyAdmin interface that they supply. And since I do not have shell access to the account, I am unable to use mysqldump. (Or if I am able to use it, I cannot figure out how). In any case, I thought it would be a simple matter to do a dump remotely using some other means. It ended up taking me hours to find a solution, so I thought I would post it here in case anyone ever needs it.

Download MySQL Administrator from http://dev.mysql.com/downloads/administrator/. This is a free download. Install it and type in the connection settings to connect to your database. You will need to know the URL or IP address, the username and the password to connect. Once connected, there is a Backup tab. You can even schedule automated backups using this feature.

Since my content changes frequently, I really need to backup often, as I would hate to lose everything in some mishap. Now that I have the ability to do this without having to depend upon my hosting company, I feel much better knowing my data is safe and can be easily restored.

Tweet
Share
Share
Pin
0 Shares
Posted in SEO

Recent Posts

  • Maximizing Your E-Commerce Sales:
    A CRO Audit Guide
  • Movin’ On Up! Why Migrating to Google Analytics 4 (GA4) Should be a Priority
  • A Year in Review: The Digital Marketing Trends That Defined 2021
  • The Basics of Video Marketing
  • Just How Much Do Google Reviews Impact Your SEO Ranking?

Categories

  • Analytics & ROI Analysis
  • Company News
  • Content
  • Conversion Optimization
  • CRO
  • Display Advertising/RTB
  • Email Marketing
  • En Español
  • En Français
  • Inbound Marketing
  • Lead Nurture & Marketing Automation
  • Local Search
  • Marketing
  • Mobile
  • Partnership Marketing
  • PPC
  • PR
  • SEO
  • Social Media Marketing
  • Web Design

Additional Posts

What is a robots.txt file?

August 7th, 2004 | by Donna Fontenot

Proof there really is a GoogleGuy!

August 5th, 2004 | by Donna Fontenot

Triangular linking strategy

August 5th, 2004 | by Donna Fontenot

LET'S TALK

Need more information or want to get in touch?

Get in touch!
  • SEO
  • SEM
  • Display
  • Blog
  • Why Us
  • Join Our Team
  • Contact Us
  • Local SEO
  • Small Business SEO
  • Enterprise SEO
  • International SEO

LOCATION

1305 Pickering Parkway,
5th Floor Pickering, L1V 3P2

PHONE

Toll Free: 1-877-695-7388
Greater Toronto Area: (647) 699-2838

Social

© Search Engine People Inc. 2023 – Canada’s Top Digital Agency
© SEP 2023 – A Search Engine People Company | Privacy Policy

Search Engine People