Ssh
This is a discussion on Ssh within the Server / Technical Administration Tips and Queries forums, part of the Webmaster Help category; Are you exporting and importing in the same encoding as well ? was it you I responded to before regarding ...
| |||||||
| Register | Forum Rules | FAQ | Donate | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
06-01-2008, 03:43 PM
| |||||
| |||||
 Are you exporting and importing in the same encoding as well ? was it you I responded to before regarding importing a sql file ? are both servers running the same versions ? Somehow I doubt running mysqldump will improve matters
__________________ Forbairt Media | Web Design & Development Galway / Dublin, Ireland - coming soon ... ( vague but descriptive isn't it ) Recent Work: Safari Club African Safari Holidays - Malawi Safaris Other Stuff: FluffyLinkulator Rapid Inclusion Service Tools Jumper Stuff: Task Drop's Official Geansai Gorm Website         |
TOTW/F/M Award(s): 1
|
06-01-2008, 05:24 PM
| |||||
| |||||
| what is the problem when you get to importing ? you've created the other database yes ? ... is the Collation the same on both databases ? Does the database contain binary data ? |
|
06-01-2008, 06:29 PM
| ||||
| ||||
| Yes, i created a new database in CPanel. No data exists in it. I exported from main database and tried to import it into new database but getting access denied errors. Databases are same collation |
|
06-01-2008, 06:54 PM
| |||||
| |||||
| you'll have to give create / potentially drop .. and various other permissions to the user you're importing as  |
|
06-01-2008, 06:59 PM
| ||||
| ||||
| I login with the Admin user for the database? I don't know whats the story Perhaps i'm exporting it incorrectly. This is what i am doing. I log in to database and go to Export I choose Select All The DatabaseName is highlighted and i click go and it saves to file Then i logout, and i login to new database with other admin credentials and choose import and select file and go. Am i doing something wrong? |
|
06-01-2008, 07:05 PM
| |||||
| |||||
| from the cpanel ... Databases -> MySQL -> MySQL DBs select your new database that you created ... Database Users should list some users ... click the edit icon beside the user you are using ... and make sure they have all the boxes ticked .. only use this user to administer the database Create a new user after that that can read .. and if needs be read / write to the database hopefully that should solve your problem ? When you assign a user to the database it by default I think has Read only access you've to change it to DBA which is database admin ... let us know how you get on |
|
06-01-2008, 07:25 PM
| |||||
| |||||
| Hmm.. All I can think is you've logged in with the wrong user when you go back to phpmyadmin ... I just tried it there and its working fine ... so I say give hosting365 a trouble ticket and see what comes back .. |
|
06-01-2008, 11:41 PM
| ||||
| ||||
| Thanks for your assistance earlier Forbairt Me being a dumbass was exporting the whole database instead of clicking into the database first and then selecting all tables and then exporting all |
 |
| Tags |
| ssh |
« How long does it take for dns changes to propagate?
|
How to get Apache 2 Test Page back - CentOS 5 »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| changing permissons via ssh | Cormac | Server / Technical Administration Tips and Queries | 5 | 15-08-2006 11:29 PM |
| ||||||||
| |  |  | ||||||
All times are GMT +1. The time now is 11:58 AM.
