Since 1and1 uses the Debian Linux distribution, all we need to do is download and extract the socat binaries on the server. If you are using Linux, you can easily install socat via your distributions software repository (apt, yum, etc.), for a Mac you can install socat via Macports. You will need to install socat on both your local machine and the 1and1 server. For more information on setting up public key authentication for SSH, see Setting up public key authentication over SSH. The goal here, is that our SSH client won’t ask us for our password every time we want to login to the server. This will add the private key to the SSH agent so that you will not be prompted for the passphrase over-and-over. Enter a passphrase for the private key (this is important for security).Simply run the following commands on your local machine (not on the 1and1 server): This is really simple and takes only a minute. Setup Public Key AuthenticationĪ crucial element in getting this working is to setup SSH public keys for authentication. Of course, since the method utilizes standard Linux utilities, getting the client working on Windows is a bit clumsy. For what it’s worth, the 1and1 servers that I have access to are running Debian 4.0 (Etch).Īs for client support, this solution is rather flexible, and you can get things to work cross-platform (Linux/Mac/Windows). So far I have tested this out on a 1and1 Managed Linux server and a 1and1 Shared Linux server. What I am going to show you in this article is how to proxy a connection to your MySQL instance on 1and1′s servers so that you can manage your databases using a full-featured application like MySQL Workbench or Sequel Pro. Although some hosting providers allow you to connect to your MySQL instances remotely, 1and1 does not support this (at least not by default). It’s only a few steps, but between pages loads and a slow internet connection this can take up to a few minutes, and even then PHPMyAdmin can be clunky especially if you are used to using a desktop MySQL management tool such as MySQL Workbench or Sequel Pro (Mac). In order to access your databases on 1and1, you must first login through the 1and1 customer portal, then navigate to the MySQL databases section, find the database you want to work with, and click on the PHPMyAdmin link. You now should be all set to use your new site.If you use for web hosting, then you are familiar with how much of a pain their MySQL management can be. If you don't do this first, you'll be editing the old sites database from the new sites admin GUI. Login to the new Joomla sites' admin interface ( Browse to Site > Global Configuration and change the MySQL parameters Hostname, Username, Password. Critical first step to using your new site. Watch for the status of the import in the main browser window, you should see the number of lines executedĥ. Paste the exported sql from the source database into the window and hit Go Choose the icon for the SQL query window in the upper left hand corner (see the online help if you can't find this) Remove the "CREATE DATABASE" and "USE" lines near the beginning of the exported database sql file Import the database you just exported to the newly created MySQL db. If you've never done this before, 1and1 has an FAQ on how to export and import MySQL databases using phpMyAdmin.Ĥ. I choose the default no compression option and saved the results to an ascii file on my local PC (good to have a backup of the db - it saved me work the first time I did this - see below). Use the 1and1 phpMyAdmin tool to do an export. Make a backup of the existing Joomla sites MySQL database. Copy source directory contents to target directory.ģ. This can take 5-10 minutes so start it now.Ģ. Use the 1and1 admin interface to create a new MySQL database for the new website. Make sure there are no changes being made to the site during this process.ġ. I'm working with a 1and1 linux developer account which means I have ssh access. This is intended to be a shorter version of what's described above with some specific steps for 1and1. The first place to look for general steps to make a duplicate copy (at another directory and URL) of an existing Joomla site is here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |