Welcome Guest ( Log In | Register )



 
Reply to this topicStart new topic
> I Have A Question About MySQL Access & Quotas
Nemisis
post Aug 26 2005, 01:16 AM
Post #1


Member [ Level 2 ]
Group Icon

Group: Members
Posts: 51
Joined: 11-August 05
Member No.: 7,777



On my previous web host, I surpassed my MySQL quota limit. At least, that's what they told me. The following message is the error I get.

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1044 Access denied for user: 'darnem_trials@65.98.98.74' to database 'darnem_trials'

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('7719681862d0a4bfc392929af1357326', 2, 1125023783, 1125023783, '18d160ac', 0, 1)

Line : 168
File : sessions.php


Now, my question is this, am I able to retrieve whatever I had on that website? If so, I need to transfer to this web host. Any help here?

This post has been edited by microscopic^earthling: Aug 26 2005, 04:03 AM
Go to the top of the page
 
+Quote Post
yordan
post Aug 26 2005, 10:16 AM
Post #2


Way Out Of Control - You need a life :)
Group Icon

Group: [MODERATOR]
Posts: 2,042
Joined: 16-August 05
Member No.: 7,896



Basically, transferring things from old_server to astahast shold be rather simple. I did not do it recently, but it should be rather straightforward.
1) On old_server, make a full database backup. Your server probably has it's tools for making the database backup, else you will have to learn how mysql does it.
2) Backup your whole site on your own pc, including the database backup. By the way, you should have done this every day, because in case of crash of your server, you need to have a backup.
3) Transfer all your files on Astahost.
4) Create your database on astahost. Remember your administrator names. I would suggest create on astahost new administrator names with the same names as on your old_server administrator names.
5) If necessary, check your php installation, probably some config files are false or need setup.
6) import your database, look your cpanel or read the mysql docs.

Hope this helped.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. MySQL - Trouble With Bulk Insert Statements(3)
  2. MySQL Realtime Replication(4)
  3. Recover Tables From A MySQL .frm File(8)
  4. Mirror My MySQL Database To Another Mysql Server(4)
  5. How To Connect MySQL With Flash?(8)
  6. MySQL Output Database Question(18)
  7. MySQL, Multiple Tables(24)
  8. Navcat For MySQL(9)
  9. Permission Problem With Mysql Database Creation(8)
  10. Mysql And Php(15)
  11. Login System Using A Mysql Db(5)
  12. Access(17)
  13. Access 97 To Access 2003(15)
  14. Mysql - So Hard(14)
  15. Mysql Problem(1)
  1. Sun Bought Mysql(6)
  2. Integrate Access Database Onto Intranet Site(5)
  3. Mysql Backup With Another Address?(4)
  4. I Have An Error With My Mysql Connection(7)
  5. Accessing Ms Access Database From A Centralized Location?(5)
  6. Mysql And User File_priv(0)
  7. Mysql Database Management(1)
  8. Mysql Database Entry By Excel Sheets(2)
  9. Mysql On Computer(9)
  10. Database Access On Remote Server W/jsp(0)
  11. Any Website Provide Free Host Mysql Host?(4)
  12. Mysql Multiple Tables(1)
  13. Mysql Overhead(3)


 



- Lo-Fi Version Time is now: 11th October 2008 - 11:35 AM