Magento Store Migration

Magento Store Migration

Articles, Database, Solutions
Chapter 1: Preparing Backup   To prepare for migration first of all we need to take backup of the magento stores and their databases. All the generic terms used throughout this document i.e. user, password, db1, folder1 etc are to be replaced with actual data as these terms are used her for conceptual purpose only. All text which is in bold is the command used in linux CLI. In order to log in to the server which holds these files use any ssh client. Normally there is a client used for this purpose i.e. putty, or mRemote. Normally any client you use to ssh into any server needs the following information. Hostname or IP Username Password So, you ought to have this information before you can ssh into any server.…
Read More
MySql Database Access Remotely

MySql Database Access Remotely

Articles, Database
To Enable Mysql user to connect remotely via any programme (tested on Heidisql) OS: Ubuntu 12.04 LTS MYSQL: mysql  Ver 14.14 Distrib 5.5.31, for debian-linux-gnu (i686) using readline 6.2 To enable user to access the DB remotely from any IP first of all edit my.cnf i.e. choosing any editor nano /etc/mysql/my.cnf change the port bind address to the public address if you are using it from outside the network if being used locally put in the private address such as “ 192.168.1.xxx” bind-address = 107.170.x.xxx (public address) then connect mysql user with mysql –u ‘user’ -p  (where user can be whichever user you are using) after that simply give the following commands CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass'; CREATE USER 'myuser'@'107.170.xxx.xxx' IDENTIFIED BY 'mypass'; ( For access from a specified…
Read More

MySQL Quick Tutorial for Mysql on Ubuntu

Articles, Database, Solutions
Databases have been here since the beginning of time (the IT Reveolution). The tutorial given below is a quick introduction of MySQL. Introduction Before we dive into working with MySQL, I want to explain a few things about MySQL and databases in general. If this is old news for you, feel free to skip on over. First, you might be wondering what the difference is between SQL and MySQL. SQL (which stands for Structured Query Language) is a programming language designed specifically for working with databases. Database servers that want to use SQL will implement the language specification. MySQL is one such database server; others include SQLite, PostgreSQL, Oracle, and SQL Server. It’s helpful to know how a database is structured. (It’s very simple, but it was by no means…
Read More