TheJeffsta
New Member
- Messages
- 984
- Reaction score
- 0
- Points
- 0
Update: No Longer Need Assistance, I have successfully transferred the database table by table via SQL Queries in phpMyAdmin.
Is there any manual way of transferring a MySQL database. I need to do this as MySQL doesn't seem to want to downgrade onto the x10hosting servers. Also if I try restoring a DB backup it will create 'jeffreyn_tjhhforum' instead of just 'tjhhforum' that I have on my other web hosting account.
I remember I tried about a month or 2 ago and then stopped cause I got to annoyed.
Any help regarding this will be much appreciated!
Update: From the SQL part of phpMyAdmin, The text file containing the stuff, I keep getting the 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 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line'
Query attempting to perform:-
'CREATE DATABASE `InvisionForum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci'
Is there any manual way of transferring a MySQL database. I need to do this as MySQL doesn't seem to want to downgrade onto the x10hosting servers. Also if I try restoring a DB backup it will create 'jeffreyn_tjhhforum' instead of just 'tjhhforum' that I have on my other web hosting account.
I remember I tried about a month or 2 ago and then stopped cause I got to annoyed.
Any help regarding this will be much appreciated!
Update: From the SQL part of phpMyAdmin, The text file containing the stuff, I keep getting the 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 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line'
Query attempting to perform:-
'CREATE DATABASE `InvisionForum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci'
Last edited: