Your Help Please

sameraeen

my database is distributed and I want to restore the backup database which is on my pc. i tried to restore through Cpanel but field to restore, per the database capacity 66MB , where the phpMyAdmin has limit (Max: 51,200K😎, I need to solve this problem by your help.

And hard thanks

devinemke

Originally posted by sameraeen
...where the phpMyAdmin has limit (Max: 51,200K😎

that is not a limitation of phpMyAdmin. phpMyAdmin is simply telling your what the upload_max_filesize directive is set in php.ini. if you have access to your php.ini you will probably need to change these vales:

max_execution_time
max_input_time
post_max_size
upload_max_filesize
mysql.connect_timeout (if you are using mySQL)

otherwise break your db up into smaller chunks and restore separately.

p.s. you don't need to post the same question 3 times.

sameraeen

thank you for your great help

I broke the file to the small files and successful restore , but when i brows the vb this error happened

Invalid SQL:
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
FROM forum AS forum

mysql error: Unknown column 'lastthread' in 'field list'

mysql error number: 1054

what is the next step to do with this erro

p.s , i'm so sorry for this

Roger_Ramjet

It is telling you exactly what it says: that there is no field named 'lastthread'. Use http://dev.mysql.com/doc/mysql/en/mysql_list_fields.html or SHOW COLUMNS FROM tbl_name to find out what fields you do have.