Transfer a Large Database using MySQL Dump and a SHH Client

Have you needed to transfer a large database? One of an eCommerce Cart or of a big blog? phpMyAdmin only allow’s imports of databases of 2 mbs, if you fix the php.ini file you can get maybe 10 or 12 max on most servers. In order to move this you will need to do it through shell access. Here is instructions on how to do this:

  1. Contact your service provider and tell them to allow shell access in your account.
  2. Download a SHH client like puTTY
  3. Open the application, enter your domain and the port. (I have usually encounter them to be 22 or 2222)
  4. Enter your username and password. These are usually the same as your FTP credentials.
  5. To export or dump the MySQL database you will be using a tool calles MySQL Dump, to do this you will type:
    1. mysqldump -u [username] -p[password] [dbname] | gzip > [location/name].sql.gzip
    2. the items in [ ] need to replaced and the brackets removed. Also please note there is no space between -p and your password
    3. This will create what is called a dump file of your database which will be gzipped for easier development.
  6. Now you need to get the file that was created and upload it to your new site via an SFTP or FTP client.
  7. After this enable shell access on your new server or location and access it
  8. First we need to decompress the .gzip file, to do this type:
  9. gzip -d [location/file].sql.gzip
  10. After this is completed the gzip file will dissapear and you will only have the sql file needed.
  11. Now all you need to do is import the file into your database, to do this type:
    1. mysql -u[username] -p[password] [dbname] < [location/file].sql
  12. Your import and transfer of your MySQL database is now complete.

————

Do you need any work performed on your database or on your web application? You can contact me at (619) 800-2678 or using the Quote Request form.

Creating Private Name Servers using Plesk

Have you ever wondered how the hosting companies are able to give you one name server of their own for all of your domains? By doing this they allow the client or the user to just be able to their domain registrar and submit that name server, instead of having the client register their own ones for every domain. An example of private name servers is how RackSpace does this, it tells you to point all of your domains to ns.rackspace.com and ns2.rackspace.com instead of doing ns.mydomain.com and ns2.mydomain.com??_ Get it???

Here is what you will need in order to complete this:

  1. Dedicated server with Plesk installed on it
  2. Domain to use as master name server
  3. Access to that domain registrar

Here are the steps that you will need to do in your server in order to set your Private Name Servers:

  1. Log into your Plesk server
  2. Create a new account for the domain you will be using for your global private name servers
  3. Once created, got to DNS Setting
  4. Click on ???Add Record???
  5. Record Type = A, On Enter Domain type ???ns2??_ , on enter IP address type in your secondary IP address (It???s usually one more than your original server IP. If your server ip is 61.55.25.1 then your secondary IP will probably be 61.55.25.2)(Configuration varies with provider)
  6. Click OK
  7. Click on ???Add Record???
  8. Record Type = NS, On Enter Domain Name type ???ns2??_ , on Enter Nameserver type NS2.MYDOMAIN.COM (Where Mydomain.com is replaced by your chosen domain)
  9. Click OK
  10. On your DNS Settings landing page there should already be records for NS.MYDOMAIN.COM, double check. If they do not exist follow the above steps, just replace NS2 with NS.
  11. Once you complete the steps, make sure you have at least 4 records, 2 for NS.MYDOMAIN.COM and 2 for NS2.MYDOMAIN.COM
  12. On your main menu, click on Settings
  13. Click on change Host Name, and where it states Full Hostname enter your chosen domain and click OK
  14. From your server???s home page select DNS Settings. Click on the default NS settings and click on it.
  15. Where it states Enter Nameserver, enter NS.MYDOMAIN.COM, click OK
  16. Click on Add DNS Record and on the Enter Nameserver, type NS2.MYDOMAIN.COM. Record type will be NS.
  17. Server configuration is complete.

After setting your server up, all you need to do is go to your Domain Registrar, and using the Domain Manager register those two name servers and point them to your domain.

Now every time you set up a new domain it will have NS.MYDOMAIN.COM and NS2.MYDOMAIN.COM as name servers. Now you can give this to your client or go to your domain registrar and just change name servers without having to register them again.

??????

Get yourξSan Diego Website Design at a reasonable price. Services include: Web Development, Website Design, iPhone Development, Mobile Development, Cloud Application Development among others.