Transfering From Godaddy To Hostgator
I have been with godaddy for almost a year and my hosting is about up. I want to move to hostgator so I can have a cpanel and continue learning. I am having a horrible time getting my databases moved. There is a compatability issue. Hostgator went and converted all but one. I have two issues. I go to config my wordpress and it only works on the index but not the blogs in the site.com/thisfolder.
Also godaddy emailed me this one database because it was not accessable to me
user_45319205-11-07.sql
"-- MySQL dump 10.9
--
-- Host: 10.0.11.206 Database: user_453192
-- ------------------------------------------------------
-- Server version4.0.27-max-log"
This I guess is not compatable with hostgator how can I take this .sql and make it so I can put it on a database on hostgator?
View Complete Forum Thread with Replies
Related Forum Messages:
Connecting A Database Using Godaddy
I have been tring to connect to my database using godaddy i keep getting an error#1064 you have an error in your SQL syntax check the manual that corresponds to your MYSQL server version for the right syntax to use near // connect to database $hostname = 'h41mysql47'.secure.net';
View Replies !
GoDaddy Importing SQL / CSV From Access
I am very new to MYSQL and have been forced to get serious about it. I had a fairly large DB in Access that I modified to match a new MySQL database. All the fields and tables are the same. I have tried to import CSV files through the SQL button at the top in MyPHPAdmin. I called GoDaddy and they said that was not allowed and that I had to create a SQL file on my computer and import it that way. So for the next couple of hours I downloaded MySQL Server(4.1) and MySQL Migration Toolkit. I got both of those to work and it went throught the migration perfectly. The migration tool did several things. It created a table file for each in .frm format and then it also created a creates.sql and inserts.sql. It seems like the two sql files should be all I need. I tried to import the sql files but I'm not sure where to do the import since I can't break the files into tables. Can someone give me some clear direction on what I could try next?
View Replies !
GoDaddy MySQL Stuff
I have just finished making a large-scale project for a client of mine and when I went to move it over to his servers I got a little confused. He uses GoDaddy and their control panel is completely different than what I'm used to (cPanel 11)... so I need some help :P I have successfully transfered the database over but now I can't seem to connect to it... oddly enough? Do I have to use some different kind of php connection script to connect to their databases or something? Here's what I currently use: $dbhost = "h50mysql9.secureserver.net"; $dbuser = "user_here"; $dbpass = "password_here"; $dbname = "name_here"; $db = mysql_pconnect($dbhost,$dbuser,$dbpass); mysql_select_db("$dbname",$db);
View Replies !
Transfering Data From 4.1.7 To 3.23.58
I have two MySQL servers, one is running 4.1.7 and the othe 3.23.58. I have tried to transfer data between the two machines but somewhere in the process something happens to the data in the tables. Some characters are changed/added, things like à etc. I'm using mysqldump to create a sql file on the 4.1.7 machine with the parameters --opt --compatible=mysql323. If I check the file manually the data is still correct. When I insert the data again on the 3.23.58 server the characters get changed/added. I have checked the character-sets on both servers, they are both set to latin1. Any ideas on how I can import the data without the changing and adding of the characters?
View Replies !
Transfering Information Between 2 Different DBs
i have an old DB done for a forum in the mambo system ( now called joomla ), but i am changing now to vbulletin system + vbadvanced. The DB i use is MySQL in both forums, but when i open the backup file from mambo and compare it to the vbulleting DB using my phpdev system, i see that they are tottally different. would you have any tip for me so i can save at least my users and their information from mambo to vbulletin? Can someone help me? It´s a very seriou forum, it´s from Alias ( 3D Maya Software productor), and so, could please somebody give me a tip? A help? A force to make me win my MySQL battle?
View Replies !
Transfering Mysql
i need to transfer my entire mysql database in order to keep my sites php message board/forum information/posts from being erased off the board. is this possible? will i have to download the database onto my computer first?
View Replies !
MySql Database Transfering
I recently got a new host and I want to take my blog from my current host and move it to my new one. I am not really sure how to go about doing this. I use pLog for my blog and im I think I have to use the installation.php again, but I'm not sure how to take my MySql DB and put it on the new server. Do I have to remake the DB or what?
View Replies !
Transfering Database From One Computer To Another
I am working on a personal site and have been usqing an MySQL database I created. I have transfered databases before by simply copying the database file itself (from the data dir) and putting it on a flash drive, then throwing it back in the data file on the other computer. Currently however I am getting this error... I can USE the database, I can even see what tables it holds, but when I try SHOW COLUMNS FROM users; it gives me this... ERROR 1146 (42S02): Table 'tome.users' doesn't exist. I have tried everything, from re-installing MySQL to checking permissions. I had a similier problem a while ago but I cannot recall how I cleared it up.
View Replies !
Transfering Records Between Tables
I have two tables 'gamestats' and 'gamestats_archive', i want to move x records from gamestats to gamestats_archive and then delete the records that have been moved from gamestats. Here is the queries that I am using: first this runs: INSERT INTO gamestats_archive SELECT * FROM gamestats WHERE date='$selecteddate' ORDER BY entry_id ASC LIMIT $maxstats then this one: DELETE FROM gamestats WHERE date='$selecteddate' ORDER BY entry_id ASC LIMIT $maxstats the problem is that the delete query is not deleting the records that have been moved, its deleting different ones. does anyone know why this might be happening?
View Replies !
Transfering Database From Local System To Live Server
I have a site running locally on my notebook and I copied my site to a live server. I have no problem getting the PHP & HTML files to the server, but i'm not sure how I can move the database and data to the live server. Can I copy a file to the live server like I can with an MS ACCESS database? Or do I need to recreate the whole database on the live server and somehow figure out how to transfer the data?
View Replies !
|
TRACKER
