error while exporting database

Permalink
Hey,
I have developed a website on my localhost with concrete5.
It is time to put it on the internet.
So I have to export my database in sql format.
I get an error while exporting.
it is about max_input_vars in php.
see attachment for more information.
in fact i am a desperate person.

best regards,

Stefaan De Reu

stedereu
 
hutman replied on at Permalink Reply
hutman
Your attachment is missing. If you have access to the command line you could export it there without having to worry about that error.
stedereu replied on at Permalink Reply 1 Attachment
stedereu
thanks,

can you help me to write the code.
I have an sql query possible on phpmyadmin.
hutman replied on at Permalink Reply
hutman
Unfortunately I don't think this is something you're going to be able to do via phpMyAdmin unless you up the max vars on the server. You could do it with SSH though.
stedereu replied on at Permalink Reply
stedereu
I will try to rebuild in my mind what I did do.
I know that I was wrong.
I use mamp pro on my iMac to develop websites.
I was working on a website within a map "pol_parol" in the htdocs map.
I also have a database with the name of "pol_parol".
I did, for experimenting with the secure ssl option, copy the "pol_parol" map to a new map "pol_parol_sec".
I did not rename the data base name! so I did some changes to the same database.
Foolish but I was sure tired.
I am unable to export the database.

how can I recover this.

the only backup I have is via Time Maschine

Is there a possibility to rebuild the website with copy and paste.
It was a hard work and a need of creativity to obtain this website.
I really can not start over again.

I ASK you if you wish to help me out of this.
The website seems to work.
I just can not export the database to put iT online.
If Needed I Will pay.
Maybe with teamviewer or something else.


Thank you
Gondwana replied on at Permalink Reply
Gondwana
If the problem occurs when exporting on localhost, you should have access to php.ini. That's what sets max_input_vars, IIRC.
jero replied on at Permalink Reply
jero
If you have MAMP installed, you probably have a program called mysqldump. This is much better tool for exporting databases that phpmyadmin. I use this tool frequently to move databases around and it works great.