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

  • Everything You Need to Know: SEM and Paid Ads
  • Embrace Performance Marketing
  • Everything You Need to Know: The Evolution of SEO
  • Everything You Need to Know | GA4 Edition
  • How to Choose the Right Agency for Your Organization

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

PHONE

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

Social

LOCATION

2 Bloor St E, Suite 3500
Toronto, ON M4W 1A8

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

Search Engine People